Skip to main content

How to use the Google Sheets plugin

Display live Google Sheets data inside your app or connect it to other features for advanced integrations.

S
Written by Support
Updated yesterday

The Google Sheets plugin allows you to embed a live Google Sheet directly into your app. This is useful for showing reports, logs, or data that updates in real time. You can also integrate Google Sheets as a data source or connect it to other plugins for dynamic functionality.


Requirements

  • This is a Boost plugin, available on specified plans only.

  • A Google Sheet shared with “Anyone with the link can view”.

  • (Optional) Google account access for users to view private or restricted sheets.


How to use the Google Sheets plugin

  1. Log in, go to Builder in the left navigation

  2. Click the + button to open the Plugin Marketplace

    • Search for Google Sheets, then click Add Plugin

    • Name your plugin (e.g., “Live Data Tracker”) and click Add

  3. Go to your Google Sheet in a new browser tab

    • Click Share → select Anyone with the link can view

    • Copy the sheet’s link

  4. Return to the Content tab in your app's Control Panel

    • Paste the Google Sheet link into the URL field

    • Save changes — your sheet will now display in your app

  5. Click the Security tab:

    • Turn on Require Login to restrict feature access to logged-in users

    • (Optional) Add tag-based restrictions and choose whether to match any or all tags

  6. Click the Tagging tab:

    • Enter a tag name to automatically apply to users when they open this feature

    • Click Add Tag

  7. Click the Purchase tab:

    • Check Require Purchase to enable

    • Choose your product type (e.g., Single Purchase or Subscription)

    • Upload an image, fill out purchase text, and success/failure messages

  8. Click the Analytics tab to see feature performance:

    • View data such as number of views, users, and devices over time


Advanced use cases

  • Integrate with the Questionnaire plugin:

    • In the Questionnaire plugin settings, enable Post to API

    • Set up your Google Sheet to receive and store responses via API

    • Display live response summaries or analytics in your Google Sheets plugin

  • Use as a Data Source in other plugins:

    • In the Control Panel, go to Settings → Integrations → Data Sources

    • Connect your Google Sheet as a new data source

    • In any plugin with a WYSIWYG editor, click Insert → Expression to pull data from the sheet

    • Use the row and column numbers (starting at zero) to reference specific cells

    • Design the output with tables or HTML formatting for better presentation


Pro tips

  • If a formula references an empty cell, it may display an error — double-check your data structure

  • Use Google Sheets to surface data that updates automatically without republishing the app

  • Combine Sheets data with the Questionnaire plugin to create dynamic feedback dashboards

Did this answer your question?