How to insert a dynamic link to data from a specific Google sheets cell in Google docs?

Question

Google Sheets

It is necessary to make substitution of the data from the table. You change the contents of the cell, the value displayed in the Google docs document also changes. How to do this?

Answer 1

Make an opening trigger that
1) opens the table (by id or url )
2) fetches data from the desired sheet or range
3) puts the data in the right places. You can search with regular expressions.
If you want a template filler, then it's better to do the opposite - there is an unchanging template that we copy, modify and save as a ready-filled document. I did just that