How to connect Bubble with Google Sheets

Go to console.cloud.google.com. Create a new project or select an existing one. Navigate to APIs & Services → Library, search for Google Sheets API, and click Enable. Then go to APIs & Services → Credentials, click Create Credentials → Service Account. Name your service account and grant it the Editor role. After creation, click the service account, go to the Keys tab, and create a new JSON key. Download this JSON file — you will need the client_email and private_key values. Finally, share your Google Sheet with the service account's email address (found in the JSON file) to grant it access.

In Bubble, go to Plugins → API Connector. Click Add another API and name it 'Google Sheets'. For authentication, since Google APIs use OAuth2 with service accounts, the simplest approach is to use a middleware service or generate an access token. Set Authentication to Private key in header. You will need to generate a Bearer token using your service account credentials. Add a shared header: Authorization = Bearer [your_access_token]. Alternatively, use a Google OAuth2 plugin or a middleware like Integromat/Make to simplify authentication. Add the base URL: https://sheets.googleapis.com/v4/spreadsheets.

In the API Connector under your Google Sheets API, click Add another call. Name it 'Get Sheet Data'. Set the method to GET. Set the URL to: /[spreadsheet_id]/values/[range]. Replace [spreadsheet_id] with a parameter (make it dynamic so you can specify different sheets). Set [range] to the sheet and cell range, e.g., Sheet1!A1:Z1000. Set Use as to Data. Click Initialize call with a real spreadsheet ID and range. Bubble will map the response — the values field contains a list of lists (rows of cells). You can now use this as a Repeating Group data source.

Add a Repeating Group to your page with data source: Get data from an external API → Google Sheets - Get Sheet Data. The response returns rows as a list. Inside each Repeating Group cell, use text elements bound to the current cell's values at specific indices. For example, if column A is Name and column B is Email, display Current Cell's values item #1 for Name and Current Cell's values item #2 for Email. Add a refresh button that re-fetches the data to show the latest sheet content.

Create another API call named 'Append Row'. Set the method to POST. Set the URL to: /[spreadsheet_id]/values/[range]:append?valueInputOption=USER_ENTERED. Set the body type to JSON and add a body parameter for the row data in the format: {"values": [["value1", "value2", "value3"]]}. Set Use as to Action. Initialize the call with sample data. In your Bubble workflow (e.g., after creating a new record), add a Plugins action → Google Sheets - Append Row, mapping your Bubble data fields to the values array. This appends a new row to the sheet each time the workflow runs.

1{
2  "values": [
3    [
4      "<customer_name>",
5      "<customer_email>",
6      "<order_total>",
7      "<order_date>"
8    ]
9  ]
10}

For automatic syncing, create a backend workflow called 'sync-sheets'. This workflow fetches the latest data from Google Sheets using the Get Sheet Data call, compares it with Bubble database records, and creates or updates records as needed. Schedule this workflow to run at regular intervals (e.g., every hour) using the Schedule API Workflow action with a recursive pattern. For the reverse direction, add an action to the backend workflow that reads recent Bubble records (created or modified since the last sync) and appends them to the Google Sheet. Store the last sync timestamp in an AppSettings Data Type to track synchronization state.