Insert linked table from Google Sheets into Google Docs using Apps Script

Question

I'd like to use Google Apps Script to do insert a linked table from Google Sheets into a Google Document.

I'm aware that this is easily done manually using Copy > Paste > Link to Spreadsheet.

But is there a way to do this programmatically using Apps Script?

If you check this SO post, everything related to your question was answered here. I think you need to dig down deeper as well in the documentation of Sheets API and Google Apps Script to understand everything. — MαπμQμαπkγVπ.0
Hi. I'm just looking at older questions, like yours, that don't have any/limited comments or answers. Did you resolve the "problem", or are you still looking for help? — Tedinoz
I did resolve the problem myself, albeit in a somewhat esoteric way. I wrote functions that would look for specifically marked fields in the Google Doc like %%table_1%% and replace these fields with tables generated from Google Sheets data. So yes, the problem could be considered solved for now. — Anton Shpigunov
Hey i understand how to create table and fill the data in Google doc. But did you solve the problem of linked copy , i.e when you change value in spreadsheet this table in doc will show refresh button to fetch the fresh data. — Sudhanshu Patel

Sudhanshu Patel Sudhanshu Patel · Accepted Answer · 2021-04-07T04:21:21

This feature is currently not available. although already raised the issue that you can track and also add your comments to prioritize it.