Refresh Sheets Chart automatically clicks the refresh button on embedded Google Sheets charts in your presentations, updating them with the latest data from your spreadsheets. Eliminates the need to manually visit each presentation and click refresh buttons on individual charts.

​
Inputs

FieldTypeRequiredDescription
Presentation URL/IDTextYesGoogle Slides presentation link or ID
Refresh TypeSelectYesChoose to refresh all charts or specific charts
Identifier TypeSelectYesHow to identify charts (Chart ID or Alt Text)
Chart IdentifiersText ListYes*IDs or alt texts of charts to refresh (*Required when refreshing specific charts)
Slide NumberNumberNoSpecific slide to refresh charts on (leave empty for all slides)

​
How It Works

This node automatically clicks the refresh button that appears on embedded Google Sheets charts when their source data changes. Instead of manually opening each presentation and clicking refresh buttons, this automation handles it for you.

​
How Google Slides Charts Work

When you embed a Google Sheets chart in Slides:
  • Chart displays the data from when it was first embedded
  • When source data in Sheets changes, a refresh button appears on the chart in Slides
  • You must click the refresh button manually to update the chart with new data
  • This node automates that clicking for you

​
Refresh Options

Refresh All Charts:
  • Clicks refresh button on every embedded chart in the presentation
  • No need to specify individual chart identifiers
  • Perfect for updating entire presentations automatically
Refresh Specific Charts:
  • Target individual charts by Chart ID or Alt Text
  • More control over which charts get updated
  • Ideal for selective updates in complex presentations

​
When to Use Refresh Charts

​
Avoid Manual Clicking

Problem: You’ve updated data in Google Sheets, but now every chart in your presentation shows a refresh button that you need to click manually. Solution: Use this node to automatically click all refresh buttons for you. Workflow:
  1. Update data in Google Sheets (via automation or manual entry)
  2. Refresh Sheets Chart automatically clicks refresh buttons
  3. Present with current data without manual intervention

​
Automated Report Updates

Scenario: Weekly sales presentations where data updates every Monday Setup: Automated workflow runs every Monday:
  1. Get fresh data from your sales platform
  2. Update Google Sheets with new numbers
  3. Refresh all charts in the presentation automatically
  4. Send updated presentation to stakeholders
Without this node: You’d need to open every presentation manually and click refresh buttons on every chart.

​
Configuration Examples

​
Refresh All Charts (Simple)

Scenario: Monthly report with multiple charts that all need updating Configuration:
  • Refresh Type: “Refresh all charts in presentation”
  • Chart Identifiers: Leave empty (not required)
  • Slide Number: Leave empty (all slides)
Result: Every embedded chart in the presentation updates with latest data automatically - no manual clicking required.

​
Refresh Specific Charts by Alt Text

Scenario: Executive dashboard where you only want to update revenue charts, not the static organizational chart Configuration:
  • Refresh Type: “Refresh specific charts”
  • Identifier Type: “Alt Text”
  • Chart Identifiers:
    • “revenue_trend_chart”
    • “monthly_revenue_chart”
    • “quarterly_revenue_chart”
Result: Only the revenue-related charts update, leaving other charts unchanged.

​
Refresh by Chart ID (Automation)

Scenario: Automated workflow where you get chart IDs from a previous Google Sheets Get Chart node Configuration:
  • Refresh Type: “Refresh specific charts”
  • Identifier Type: “Chart ID”
  • Chart Identifiers: Connect from previous node output
  • Slide Number: 3 (only refresh charts on slide 3)

​
Best Practices

​
Workflow Integration

Always refresh after data updates: 
Data Source → Google Sheets → Refresh Sheets Chart → Present/Share
Eliminate manual work: 
Without automation: Data Update → Open Slides → Click refresh button on each chart → Present
With automation: Data Update → Refresh Sheets Chart node → Present

​
Timing Considerations

  • Refresh after updating data in Google Sheets to sync presentations
  • Use in scheduled workflows for regular report updates
  • Refresh before sharing presentations to ensure current data
  • Automate to avoid manual clicking on refresh buttons

​
Alt Text Strategy

  • Set descriptive alt text on charts for easy identification
  • Use consistent naming like “monthly_sales_chart” across presentations
  • Group related charts with similar alt text patterns for batch updates

​
Refresh vs Manual Clicking

​
How Google Slides Charts Actually Work

  • Charts don’t auto-update when source data changes in Google Sheets
  • A refresh button appears on each chart when data changes
  • You must click each refresh button manually to update the chart
  • This is tedious when you have multiple charts or presentations

​
Why Use This Node

  • Automates the clicking of refresh buttons for you
  • Saves time especially with multiple charts or presentations
  • Perfect for scheduled workflows where manual clicking isn’t practical
  • Ensures charts are always current without manual intervention

​
Credit Cost

1 credit per successful run.

​
FAQ