When a new row is added in Google Sheets, render image from template in Orshot
Add a row to Google Sheets and this workflow renders an image from one of your Orshot templates using that row’s values, so a spreadsheet of names, quotes or prices turns into graphics one row at a time.
Google Sheets
Orshot2 steps Setup ~5 min Used on 1.8k sites Free to import
What this workflow does
Making the same graphic again and again with new text is slow work. Quote cards, event speakers, product announcements and certificates all follow a template where only the words change. This workflow keeps the words in a Google Sheet and lets Orshot produce the image for each new row.
The Google Sheets trigger fires on New Spreadsheet Row in the sheet you connect and passes each column's value to FlowMattic. The second step runs Orshot Render From Template, where you map those values into your chosen template. Orshot returns the rendered result, which shows up in the run's data.
As imported, the image stays with Orshot and in the step's output. To send it somewhere, such as an email, a chat message or back to the sheet, add another step and map in what Orshot returns. Add a sample row after import to see that output before you build on it.
Speaker cards for an event
Each speaker you add to the sheet, with name and talk title, becomes a branded card rendered from the same Orshot template.
Quote graphics for social media
Write a customer quote and its author in a new row, and Orshot renders a quote card ready for your social posts.
Certificates for course completions
Add each graduate to the sheet and get a certificate image with their name filled in from the template.
How this workflow runs
What happens at each step once the workflow is on, and what you need before you import it.
Google Sheets New Spreadsheet RowStarts the workflow when a new row is added to the Google Sheets spreadsheet you connect. Each column's value is passed on for the Orshot step.
- Orshot Render From Template
Renders an image from an Orshot template, filling it with the values you map from the new row. Run a test to see what Orshot returns for the rendered image.
What you need
- FlowMatticCore
- Google Sheets AccountAccount
- Orshot AccountAccount
After importing, map your own data. To keep the template universal, not every step is pre-filled. Open each step in the builder and connect your accounts and fields (channels, lists, sheets, recipients) before you switch the workflow on.
Make it yours
Changes worth making after you import it.
- Add a Google Sheets Update Row step after Orshot to write the rendered image's link back next to the data, if Orshot returns one in your test run.
- Add a Filter after the trigger so rows with an empty headline or name are not rendered, saving you from blank graphics.
- Put a Slack, Gmail or other action after the render step to send each new image straight to the person who will post it.
Questions about this workflow
Will rows already in the sheet be rendered?
No. Only rows added after the workflow is turned on trigger it. Copy older rows into the sheet again if you want images for them.
Where does the finished image go?
As imported, the workflow ends at the Orshot step, and the result shows in that step's output in Task History. Add a step after it to send or store the image.
Do I need an Orshot template ready before importing?
Yes. The step renders from a template in your Orshot account, so set one up first and then map sheet columns into it.
Can one Google Sheet feed several Orshot templates?
Use a Router after the trigger with a route per template, each with its own render step, and give the routes conditions that cannot both match.
More Marketing workflows
Other ready-to-import templates from the same category.
Import this workflow into your WordPress site
Download the JSON, import it from the Workflows screen and connect your accounts. Every run stays on your server, with no per-task fees.
30-day money-back guarantee Unlimited workflows and runs Self-hosted