I’m working on a project where I have a Google document embedded in an iframe on my website. This document is set up for public editing and includes charts that are linked to data from a public Google spreadsheet.
Here’s my problem: when I modify the spreadsheet data using the Google Sheets API, the charts in the document don’t update automatically. The manual refresh buttons are greyed out and can’t be clicked since it’s in an iframe.
I’ve tried looking into both Google Docs API and Apps Script solutions but haven’t found a working approach yet. The Docs API doesn’t seem to have a chart refresh method, and Apps Script doesn’t execute properly within the iframe environment.
Does anyone know a way to force these linked charts to refresh programmatically? Any suggestions would be helpful.
Had the same problem last year and found a workaround that works. Don’t bother trying to refresh charts directly - use Apps Script with a time-based trigger to recreate the chart objects periodically. The script pulls updated data from your spreadsheet and swaps out the old chart with a fresh one. Works because it runs server-side, so you skip the iframe headaches. Just set your trigger interval to match how often your data updates. Use DocumentApp.openById() to grab the document, then find your chart elements in the body. Not pretty, but it’s reliable for automated updates.
Iframe blocks most refresh methods, but here’s a workaround. Don’t fight the iframe - set up a webhook that watches your spreadsheet for changes and rebuilds the entire Google Doc with fresh chart references. When your Sheets API updates the data, trigger a background process to clone your doc template and embed new charts from the updated spreadsheet. Then just point your iframe to the new document URL. You’re bypassing the refresh issue completely since you’re using brand new chart objects with current data. More setup work upfront, but no more manual refresh headaches.
iframe restrictions are your problem. Skip the iframe - make a simple redirect page that opens the Google doc directly. The refresh buttons’ll work fine and users can update charts manually. Or just switch to Google Sites - it handles embedded sheets way better than custom iframes.
Google Docs treats linked charts as static once they’re in an iframe - ran into this exact problem building a quarterly dashboard. Here’s what worked: use the Google Docs API’s batchUpdate method to target the chart’s embeddedObject ID and swap it out completely with a fresh reference. First, grab your chart objects with documents.get, then build a replaceNamedRangeContentRequest or deleteContentRangeRequest + insertInlineImageRequest that points to your updated spreadsheet chart. The key is generating a new chart URL from your spreadsheet using Sheets API’s charts.get method after your data changes. You’re basically creating new chart instances instead of updating existing ones - bypasses the refresh issue entirely. More API calls but it’s reliable in iframes.
Been dealing with this for years. The iframe isn’t your only problem - Google’s APIs just don’t work well together for this kind of setup.
You need something that can handle all the moving parts automatically. When your spreadsheet changes, you want it to trigger a sequence that refreshes chart references in your doc without hitting Google’s API walls.
I built something similar with Latenode. It watches for spreadsheet changes through webhooks, then hits the Google Docs API to swap in fresh chart objects. Best part? It handles all the API coordination and retry stuff automatically.
Set up a workflow that catches data changes, pulls new chart URLs from your updated sheet, and drops them into your document. No more iframe headaches or manual refresh buttons.
The visual builder makes it simple to chain together Sheets monitoring, chart generation, and doc updates. Runs in the cloud too, so no server setup or Apps Script limits to worry about.