Skip to main content

From a Google Sheet to a Google Slides infographic

The Fused Google Drive integration lets a UDF reach straight into your Drive — read any file, list any folder, write back, all with one OAuth grant. This example uses it to take a CSV sitting in Drive, render it as an editorial infographic with an AI image model, and drop the result as a new slide into an existing Google Slides deck. The same pattern works for any Drive file: Sheets, Docs, PDFs, images — once you're connected, it's all one filesystem.

Try it out​

Open the Fused Canvas →

Make a copy first

The Canvas references your own Google Drive and your own OpenRouter key, so fork it into your workspace before running: open the Canvas → click ⋮ → Make a copy, then work in your copy.

Two things to set up before you run
  • Connect Google Drive — Workbench → Integrations & Secrets → Google Drive → Connect, then use the Picker to grant access to the spreadsheet folder you want to read and the Slides decks you want to publish into. With the drive.file scope, Fused only sees files you explicitly grant — a deck won't appear in the picker on the last node until you've added it via the Picker.
  • Add an OpenRouter API key — get one from OpenRouter, then Workbench → Preferences → Environment → Secrets management (docs) and add it as openrouter_api_key.

How the Canvas is organized​

Three folders on the top row, each a single click for the user. Two more folders at the bottom hold the supporting UDFs — you don't normally touch them.

Part 1 · Pick data from Google Drive​

Lists every CSV / XLSX you've granted Drive access to and lets you pick one — the file streams straight into a pandas DataFrame, no intermediate copy. Built from a dropdown and a sql-table widget.

Part 2 · Generate the infographic​

Pick a style reference, type a title, click Generate. An image model on OpenRouter renders the chart in that style and the PNG is saved to your Drive. Built from a gallery-input for the style picker and a form so the generator only fires on submit.

Part 3 · Publish into a Google Slides deck​

Pick a deck, set the insert position, click Publish. A new slide lands in the deck with the title from Part 2 and the infographic as a full-bleed image, then an embedded preview renders right below the form. Built from a dropdown, a number-input, and a form.

"I don't see my deck in the dropdown"

Slides decks only appear in the picker once they've been explicitly granted via the Drive Picker. Open Integrations & Secrets → Google Drive → Picker and add the deck you want before refreshing the Part 3 widget.

Let Part 2 finish before clicking Publish

Part 2 sets a canvas parameter once the infographic preview renders. If you click Publish before the preview shows up, that parameter is still empty and the slide will land with just a title and no image. Wait for the infographic to appear, then publish.

See also​