Integrations

Google Sheets

Automate creating branded images, PDFs, banners, short videos, and more by using Robolly to render visuals directly from data in Google Sheets.

Robolly is a cloud-based image, PDF, and video rendering platform that lets you design a template once and generate unlimited personalized assets at scale. It offers a fully official Google Workspace Add-on that dramatically simplifies the entire workflow – no manual formulas, no CSV exports for bulk rendering, and everything happens inside your spreadsheet.

Official Robolly Google Add-on

(Simplest & most powerful approach)

Robolly now has an official Google Workspace Add-on called Robolly — Image & PDF Generator. Install it once from the Google Workspace Marketplace and turn any Google Sheet into a complete visual automation hub.

Robolly Official Google Workspace Add-on

How to use the Add-on (5 simple steps)

  1. Install the add-on
    Go to the Google Workspace Marketplace link → Install → Authorize.

  2. Connect your Robolly account
    In Google Sheets, open Extensions → Robolly — Image & PDF Generator.
    Enter your Robolly API key (find it in your Robolly dashboard under Account settings → API key).

  3. Choose template(s)
    Select any template from your Robolly library.

    Robolly Official Google Workspace Add-on – Choose template

  4. Map columns
    The add-on will auto-detect and map your sheet columns to the editable elements in the template (text, images, colors, etc.). You can adjust mappings manually if needed.

    Robolly Official Google Workspace Add-on – Map columns

  5. Render
    Choose output options (format, scale, Drive folder).
    Hit Render. The add-on saves the files directly to a Google Drive folder (nicely organized by date) or writes the resulting URLs back into your sheet.

    Robolly Official Google Workspace Add-on – Render

Pro tip: The add-on remembers your settings, so re-running on updated data is lightning fast.

Key Features

  • One-click bulk rendering of all rows (or selected rows)
  • Direct rendering of images (JPG, PNG, WebP), PDFs, and short videos
  • Render at 0.5×, 1×, 2×, or 3× scale
  • Auto-maps your column names to template elements (or map manually)
  • Save files automatically to a Google Drive folder (organized by date)
  • Support for multiple templates per row in a single run
  • Settings are remembered per spreadsheet
  • No code, no formulas, no leaving Google Sheets

Perfect for social media graphics, news cards, personalized certificates, product images, email headers, PDF reports/invoices, and more.

(Still available but no longer recommended approach)

Another method is to use Robolly Google Sheets Wizard (found in the template’s Render tab in the Robolly Dashboard). This works for simple one-row-at-a-time rendering via render link formulas. However, the official add-on is much faster and more powerful for real workflows.

To use this method:

  1. Create/import a template in Robolly.
  2. Use the Google Sheets setup wizard in the Render tab to generate a formula.
  3. Paste it into your sheet.

FAQ

Can I render everything in one click (bulk rendering)?

Yes! With the official add-on you can now render hundreds or thousands of rows in one go directly inside Google Sheets.

Is it possible to customize colors of rectangles/circles?

Yes, just add a column in your sheet with hex colors (e.g. #FF0000) and map it to the corresponding element in the add-on (or Google Sheets wizard).

Results will look like this:

#2 row render#3 row render

Can I customize fonts?

Fonts cannot be customized at this time. However, as a workaround, I suggest duplicating your template and setting up multiple templates with different fonts. This way, you can still achieve the desired look.

Does it support videos?

Yes! The add-on supports short video rendering (when your Robolly plan includes the Video element).

Do I need a Robolly paid plan?

The add-on itself is free. You need a Robolly account (free 7-day trial available at robolly.com). Rendering consumes your Robolly rendering credits/plan limits.

Where are the generated files saved?

You can choose to get URLs in the sheet or have files automatically saved to a Google Drive folder.

Can I use multiple templates in one run?

Yes, the add-on supports multi-template rendering per row.

I already have a sheet set up with the old wizard formulas. Do I need to change anything?

No rush – old formulas still work. For new sheets or bulk work, we strongly recommend switching to the add-on.

More resources & tutorials: