How to connect Bubble with Google Sheets

You can connect Bubble to Google Sheets in two reliable ways: using a plugin (the easiest) or using the API Connector with Google’s official API (the most flexible). For most people, the fastest working solution is installing the “SheetDB” or “Blockspring (Retool) for Google Sheets” plugin. If you need full control, use the API Connector with a Google Service Account.

Option 1 — Use a Plugin (easiest)

Plugins handle authentication for you and expose actions like “Get sheet values” or “Create a new row”. After installing a Google Sheets plugin:

• Create your Google Sheet normally.
• Connect the plugin to your Google account (OAuth popup).
• Use actions in workflows such as “Create Row in Google Sheets” or “Get Data from Google Sheets”.

This works well for simple apps, reporting dashboards, or sending form submissions into Sheets.

Option 2 — API Connector + Google Sheets API (for full control)

This uses a Google Service Account because Bubble cannot keep interactive OAuth tokens alive easily. A Service Account is like a robot user that accesses your sheet.

• Create a Google Cloud project.
• Enable the Google Sheets API.
• Create a Service Account.
• Generate a JSON key.
• Open your Google Sheet → Share → share it with the service account email.

In Bubble’s API Connector, you define a call using JWT-based OAuth. Bubble supports Private key JWT for Google APIs.

{
 "type": "service_account",
 "project_id": "your-project",
 "private_key": "-----BEGIN PRIVATE KEY-----\n...\n-----END PRIVATE KEY-----\n",
 "client_email": "[email protected]"
}

For example, to read values:

GET https://sheets.googleapis.com/v4/spreadsheets/SPREADSHEET_ID/values/Sheet1!A1:C10

Once authenticated, you can:

• Trigger backend workflows to append rows to Sheets.
• Read data into Bubble repeating groups.
• Sync data into your database using scheduled API workflows.

This option is ideal when you need automation, stable credentials, and large-volume workflows.