Update Linked Tables and Charts Using Google Docs API [124793822]

Assigned

Feature Request

Status Update

No update yet.

Description

fi...@gmail.com

created issue #1

Feb 20, 2019 08:00AM

Unable to update tables linked from google spreadsheet using Google Docs API.

Issue discussed here:

https://stackoverflow.com/q/54772429/2296728

Comments

sp...@gmail.com <sp...@gmail.com> #2Feb 26, 2019 06:33PM

js...@cpusb.com <js...@cpusb.com> #3Mar 28, 2019 02:09AM

I need it...

fi...@gmail.com <fi...@gmail.com> #4Mar 28, 2019 03:05AM

please star the issue

gt...@gmail.com <gt...@gmail.com> #5Apr 28, 2019 11:20PM

I need this functionality as well

ek...@google.com <ek...@google.com> #6May 20, 2019 12:53PM

The API currently doesn't provide this feature, so switching to a feature request. You can find the list of currently supported requests here:

https://developers.google.com/docs/api/reference/rest/v1/documents/request

ro...@gmail.com <ro...@gmail.com> #7Oct 23, 2019 02:03AM

adding my request for this feature!

al...@gmail.com <al...@gmail.com> #8Mar 2, 2020 01:46AM

ak...@deltax.com <ak...@deltax.com> #9Jun 25, 2020 11:28AM

[Deleted User] <[Deleted User]> #10Aug 3, 2020 03:24PM

[Deleted User] <[Deleted User]> #11Sep 30, 2020 08:17PM

[Deleted User] <[Deleted User]> #12Sep 30, 2020 08:27PM

i would also benefit from this

[Deleted User] <[Deleted User]> #13Oct 14, 2020 03:58PM

mb...@gmail.com <mb...@gmail.com> #14Dec 8, 2020 07:37AM

co...@googlemail.com <co...@googlemail.com> #15Dec 9, 2020 11:56AM

[Deleted User] <[Deleted User]> #16Feb 13, 2021 02:55PM

aa...@gmail.com <aa...@gmail.com> #17Mar 20, 2021 11:41AM

Google, why do you ignore this issue? Are you hate your users?

Message last modified on Mar 20, 2021 11:41AM

si...@gmail.com <si...@gmail.com> #18Apr 5, 2021 02:08PM

Hi there!

I ran the following code and deployed the script as an add-on:

function doGet() {
  return HtmlService.createHtmlOutput(ScriptApp.getService().getUrl())
}

using the V8 runtime environment. When I visited the Web App, the /exec link was displayed correctly.

Therefore it appears that the /exec link gets produced correctly in the Web App environment, and I was unable to reproduce this behaviour.

If you can still reproduce this behaviour, please provide all step-by-step instructions on how to achieve this so I can look at it again.

Many thanks!

si...@gmail.com <si...@gmail.com> #19Apr 5, 2021 02:10PM

https://issuetracker.google.com/124793822 Update Linked Tables Using Google Docs API

cr...@iol.unh.edu <cr...@iol.unh.edu> #20Apr 7, 2021 04:25PM

Comment #18, what does that have to do with this Feature request in any way??? LOL

[Deleted User] <[Deleted User]> #21May 2, 2021 07:37PM

jo...@kantar.com <jo...@kantar.com> #22May 11, 2021 12:42PM

as...@sonntaganalytics.com <as...@sonntaganalytics.com> #23Jul 7, 2021 05:05PM

Please, for the love of God.

ar...@googlemail.com <ar...@googlemail.com> #24Jul 16, 2021 10:03PM

el...@gmail.com <el...@gmail.com> #25Aug 11, 2021 03:55PM

cc...@gmail.com <cc...@gmail.com> #26Aug 12, 2021 05:14PM

[Deleted User] <[Deleted User]> #27Aug 12, 2021 05:15PM

sj...@gmail.com <sj...@gmail.com> #28Aug 12, 2021 05:38PM

sg...@gmail.com <sg...@gmail.com> #29Oct 10, 2021 08:41PM

de...@airliquide.com <de...@airliquide.com> #30Feb 15, 2022 02:06PM

cu...@gmail.com <cu...@gmail.com> #31Mar 10, 2022 01:16PM

da...@gmail.com <da...@gmail.com> #32Apr 5, 2022 03:45PM

qd...@thoughtworks.com <qd...@thoughtworks.com> #33May 11, 2022 09:27PM

yk...@gmail.com <yk...@gmail.com> #34May 13, 2022 09:40AM

mh...@gmail.com <mh...@gmail.com> #35Jun 7, 2022 05:57AM

[Deleted User] <[Deleted User]> #36Jun 8, 2022 12:41PM

da...@gmail.com <da...@gmail.com> #37Jul 26, 2022 11:23AM

ko...@gmail.com <ko...@gmail.com> #38Aug 7, 2022 10:09AM

pi...@gmail.com <pi...@gmail.com> #39Aug 24, 2022 11:53AM

[Deleted User] <[Deleted User]> #40Aug 24, 2022 11:54AM

an...@idex.fr <an...@idex.fr> #41Sep 15, 2022 07:09AM

la...@gmail.com <la...@gmail.com> #42Sep 22, 2022 07:29AM

Really - still no way to do this? After 3 years? Please google ......

dm...@gmail.com <dm...@gmail.com> #43Dec 6, 2022 09:14AM

gc...@ashlandfood.coop <gc...@ashlandfood.coop> #44Dec 10, 2022 12:37AM

al...@gmail.com <al...@gmail.com> #45Dec 16, 2022 08:05AM

Come on google

ra...@gmail.com <ra...@gmail.com> #46Mar 13, 2023 12:01PM

ir...@gmail.com <ir...@gmail.com> #47Mar 15, 2023 10:54AM

st...@metawork.studio <st...@metawork.studio> #48Mar 15, 2023 06:07PM

MUST have feature for integration!

by...@motorolasolutions.com <by...@motorolasolutions.com> #49Apr 24, 2023 10:53AM

Come on google it's been 3 years and still no update?

jp...@google.com <jp...@google.com> Jul 13, 2023 01:33AM

Assigned to wo...@google.com.

ph...@gmail.com <ph...@gmail.com> #50Jul 20, 2023 03:39PM

ma...@gmail.com <ma...@gmail.com> #51Jul 31, 2023 06:58PM

Huge tables can't be linked, there should be a way to work it out. This might be it.

su...@gmail.com <su...@gmail.com> #52Jul 31, 2023 07:25PM

My importRange links do not try to import large amounts of data. But I am still having the issues.
What I have done is create a routine to copy imported date to another sheet.
So, I open the spreadsheet and the data is imported, I run the routine (Google script) to copy the data to another sheet and after a while the importRange function stops working - but I have the data on the second sheet.
What a waste of time this is!
Please get the functions working!

on...@gmail.com <on...@gmail.com> #53Aug 8, 2023 10:48PM

ni...@gmail.com <ni...@gmail.com> #54Aug 30, 2023 12:06PM

Comment has been deleted.

Message last modified on Aug 30, 2023 12:21PM

jo...@gmail.com <jo...@gmail.com> #55Sep 1, 2023 04:59PM

sa...@gmail.com <sa...@gmail.com> #56Sep 9, 2023 09:02AM

Looks like many waiting for the update from Google.
+1

ar...@gmail.com <ar...@gmail.com> #57Sep 22, 2023 09:50AM

st...@metawork.studio <st...@metawork.studio> #58Nov 8, 2023 02:36PM

ha...@gmail.com <ha...@gmail.com> #59Dec 18, 2023 04:26AM

ha...@dcp.vc <ha...@dcp.vc> #60Dec 22, 2023 07:59AM

+1 This is an important feature lacking.

ry...@gmail.com <ry...@gmail.com> #61Jul 12, 2024 06:20PM

This would really solve some issues and allow for some useful projects

sy...@daviswaldorf.org <sy...@daviswaldorf.org> #62Jul 30, 2024 05:39PM

+ 1

pr...@gmail.com <pr...@gmail.com> #63Aug 4, 2024 02:02PM

g....@gmail.com <g....@gmail.com> #64Sep 5, 2024 08:54PM

do...@gmail.com <do...@gmail.com> #65Oct 2, 2024 04:27AM

gh...@gmail.com <gh...@gmail.com> #66Oct 22, 2024 10:45AM

Totally agree. It would be useful to add:

a refresh button for tables of contents and linked objects via mobile app;
implement a function to refresh these elementsi via apps script or Docs API.

Impact

Every time a document structure is updated, it is required to refresh the table of contents to keep the information updated. The same happens with tables and charts linked to spreadsheets changing frequently. To refresh all of these dynamic contents manually every time slows down productivity.

cr...@iol.unh.edu <cr...@iol.unh.edu> #67Oct 22, 2024 12:37PM

I would argue it should be an option whether to manually or automatically update these things. I would not want to be unable to set it to have to be manual as our use case depends on things not updating until we specifically need to. Our real need lies in being able to change the linked source document to an identically formatted but different contents (and document ID) spreadsheet, this would hopefully be possible with this feature.

ni...@gmail.com <ni...@gmail.com> #68Dec 2, 2024 12:31AM

ma...@gmail.com <ma...@gmail.com> #69Jan 22, 2025 08:41PM

+1

Would also love this. I have created a custom table in Google Sheets that automatically pulls weather data (using a script) every 15 minutes from a Weather API, and then I link that table onto a Google Doc. This Google doc is used by radio announcers to read live weather data, along with other announcements on the Doc. However, the only way for that updated data to land on the Doc is by manually updating the linked object. You can't do that without editorial access to the Doc, which is not feasible in our system/workflow (I don't want/need everyone to have editorial access to the doc). Would love it if I can set up an automatic trigger to update this information in the doc, similar to how the trigger works in Google Sheets.