Google Sheet Component

Aroa Gil Bo

Google Sheet Component

This component isn’t actively supported anymore. Please use the Data Component by Iain Kettles instead. You can download the CSV / TSV from the google sheet and input it in the Data Component.


This Google Sheets Component allows you to connect any of your Google Spreadsheets files with any design component in your canvas, without any code!

How does it work?

It’s super easy! You just need to follow three simple steps:

  1. Create a design component in the canvas and enable the layers to be overriden. Make sure you name the design overrides the same as the columns you want to retrieve from your data base.


    • Names are case sensitive.
    • Spaces are not accepted. Column names that contain spaces cannot be retrieved, so in order to retrieve it you can change the space for a _ or use Camel casing.
  2. Enter your Google Sheets “Published to Web” Link (csv or tsv) on the component’s properties section.

    Your url should look like something similar to this: e.g.

    Note: If you don’t know how to get this link, follow this steps:

    1. Go to the file you want to publish, At the top, click File and then Publish to the web.
    2. If you have multiple sheets, instead of entire select the sheet you are interested in.
    3. Choose csv or tsv as a publishing format instead of the default “Web Page”
    4. Click Publish and you got the link!

    See here for more information.

    If you entered a valid link, a ✅ sign will appear on step 2.

  3. Connect the Google Sheets component to your design component.


What does it do?

It will populate the design component you created with the data coming from your Google Spreadsheet and duplicate it as many times as the number of rows in your data.

All the cards are going to be inside a scrollable area, which can be horizontal or vertical, so it can be fully adapted to your designs. It also offers all the Stack’s options so you can customize it even further.

Note: After you have made changes to the document, google’s API takes a bit (about 5 min) to push the update - Be patient!

Contact me

If you come up with more functionality or you find any bugs, please contact me!

Twitter: @aroagilbo Email:

Changelog & Roadmap

Version 1.5 -> Support for OnTap ()

Version 1.6 -> Added scrollable property control for user to select if they want the area to be scrollable or not.