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
– MαπμQμαπkγVπ.0, Commented Aug 16, 2018 at 11:59
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
– Tedinoz, Commented Jan 9, 2019 at 0:29
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
– Anton Shpigunov, Commented Jan 9, 2019 at 22:02
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, Commented Oct 11, 2020 at 1:30

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

2

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

answered Apr 7, 2021 at 4:21

Sudhanshu Patel

8091 gold badge6 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1