---
title: How to use the Google Sheets plugin
description: Display live Google Sheets data inside your app or connect it to other features for advanced integrations.
---

[Skip to content](https://help.buildfire.com/how-to-use-the-google-sheets-plugin#main-content)

[![buildfire](https://help.buildfire.com/hs-fs/hubfs/bf-wordmark-black.png?width=150&height=35&name=bf-wordmark-black.png)](https://help.buildfire.com?hsLang=en-us)

Open main navigation

Close main navigation

- [Log In](https://app.buildfire.com/login)

[Log In](https://app.buildfire.com/login)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Buildfire Help Docs](https://help.buildfire.com/?hsLang=en-us)
2. [Add Functionality To Your App](https://help.buildfire.com/add-functionality-to-your-app?hsLang=en-us)
3. [Plugins to show content & media](https://help.buildfire.com/add-functionality-to-your-app?hsLang=en-us#plugins-to-show-content-media)

# How to use the Google Sheets plugin

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

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 the Standard, Growth, and Scale plans
- 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 Buildfire 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](https://49206840.hs-sites.com/how-to-use-the-questionnaire-plugin-buildfire-university?hsLang=en-us):**

    - 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

- [Buildfire Control Panel](https://help.buildfire.com/buildfire-control-panel?hsLang=en-us#main-content)

    - [Navigating the Control Panel](https://help.buildfire.com/buildfire-control-panel?hsLang=en-us#navigating-the-control-panel)
    - [Global Tools](https://help.buildfire.com/buildfire-control-panel?hsLang=en-us#global-tools)
    - [Terms & Policies](https://help.buildfire.com/buildfire-control-panel?hsLang=en-us#terms-policies)
- [Build Your App](https://help.buildfire.com/build-your-app?hsLang=en-us#main-content)

    - [Global Settings](https://help.buildfire.com/build-your-app?hsLang=en-us#global-settings)
    - [Building Your App's Navigation](https://help.buildfire.com/build-your-app?hsLang=en-us#building-your-apps-navigation)
    - [Building Your Login Flow](https://help.buildfire.com/build-your-app?hsLang=en-us#building-your-login-flow)
    - [Building a PWA](https://help.buildfire.com/build-your-app?hsLang=en-us#building-a-pwa)
- [Add Functionality To Your App](https://help.buildfire.com/add-functionality-to-your-app?hsLang=en-us#main-content)

    - [Plugins to drive engagement & community](https://help.buildfire.com/add-functionality-to-your-app?hsLang=en-us#plugins-to-drive-engagement-community)
    - [Plugins to drive monetization](https://help.buildfire.com/add-functionality-to-your-app?hsLang=en-us#plugins-to-drive-monetization)
    - [Plugins to run operations & workflows](https://help.buildfire.com/add-functionality-to-your-app?hsLang=en-us#plugins-to-run-operations-workflows)
    - [Plugins to show content & media](https://help.buildfire.com/add-functionality-to-your-app?hsLang=en-us#plugins-to-show-content-media)
- [Make Money With Your App](https://help.buildfire.com/make-money-with-your-app?hsLang=en-us#main-content)

    - [Overview](https://help.buildfire.com/make-money-with-your-app?hsLang=en-us#overview)
    - [Apple/iOS](https://help.buildfire.com/make-money-with-your-app?hsLang=en-us#apple-ios)
    - [Google/Android](https://help.buildfire.com/make-money-with-your-app?hsLang=en-us#google-android)
- [Publish Your App](https://help.buildfire.com/publish-your-app?hsLang=en-us#main-content)

    - [Overview](https://help.buildfire.com/publish-your-app?hsLang=en-us#overview)
    - [Apple/iOS](https://help.buildfire.com/publish-your-app?hsLang=en-us#apple-ios)
    - [Google/Android](https://help.buildfire.com/publish-your-app?hsLang=en-us#google-android)
- [Manage Your App](https://help.buildfire.com/manage-your-app?hsLang=en-us#main-content)

    - [Managing Your App’s Users](https://help.buildfire.com/manage-your-app?hsLang=en-us#managing-your-apps-users)
    - [Push Notifications](https://help.buildfire.com/manage-your-app?hsLang=en-us#push-notifications)
    - [Analytics](https://help.buildfire.com/manage-your-app?hsLang=en-us#analytics)
- [Connect External Partners](https://help.buildfire.com/connect-external-partners?hsLang=en-us#main-content)

    - [Google/Android](https://help.buildfire.com/connect-external-partners?hsLang=en-us#google-android)
    - [Apple/iOS](https://help.buildfire.com/connect-external-partners?hsLang=en-us#apple-ios)
    - [Zapier](https://help.buildfire.com/connect-external-partners?hsLang=en-us#zapier)
    - [Meta](https://help.buildfire.com/connect-external-partners?hsLang=en-us#meta)
    - [Segment](https://help.buildfire.com/connect-external-partners?hsLang=en-us#segment)

[![Group 4578 (1)](https://help.buildfire.com/hs-fs/hubfs/Group%204578%20(1).png?width=140&height=33&name=Group%204578%20(1).png "Group 4578 (1)")](https://buildfire.com/)

Copyright © 2026, Buildfire