Google Sheets Integration
Connect Google Sheets to automatically sync bookings and estimates data
Prerequisites
- • Google account with Google Sheets access
- • Admin access to your Widgetfied account
- • Service account email (provided below)
1Create Your Google Sheets
You'll need two separate Google Sheets - one for bookings and one for estimates.
Create Bookings Sheet
- 1. Go to Google Sheets
- 2. Click "Blank" to create a new spreadsheet
- 3. Name it something like "Widget Bookings"
- 4. Keep this tab open - you'll need the Sheet ID
Create Estimates Sheet
- 1. Create another new spreadsheet
- 2. Name it something like "Widget Estimates"
- 3. Keep this tab open as well
2Get Your Sheet IDs
The Sheet ID is found in the URL of your Google Sheet:
https://docs.google.com/spreadsheets/d/1abc...xyz/editThe ID is the long string between /d/ and /edit
Bookings Sheet ID
Copy this from your Bookings sheet URL
Estimates Sheet ID
Copy this from your Estimates sheet URL
3Share Sheets with Service Account
Important: Service Account Email
widget-b@secure-bongo-472822-d7.iam.gserviceaccount.comFor each Google Sheet (both Bookings and Estimates):
- 1
Click the Share button in the top-right corner
- 2
Paste the service account email:
widget-b@secure-bongo-472822-d7.iam.gserviceaccount.com - 3
Set permission to Editor
This allows the widget to read and write data
- 4
Uncheck "Notify people" (optional)
- 5
Click Share
4Add Sheet IDs to Your Account
Now add the Sheet IDs to your Widgetfied account:
During Onboarding
If you're setting up a new account, you'll see fields for Sheet IDs in the Configuration section of the setup form.
After Account Creation
- 1. Log in to your Widgetfied Dashboard
- 2. Select the 'Config' button on the widget card you want to configure
- 3. Find the 'Google Sheets' section
- 4. Enter your Bookings Sheet ID for Bookings Widget
- 5. Enter your Estimates Sheet ID for Estimates Widget
- 6. Click Save
Verify Your Setup
To verify everything is working correctly:
Create a test booking through your widget
The booking should appear in your Google Sheet within seconds
Submit a test estimate request
The estimate should sync to your Estimates sheet
Check the sheet permissions
You should see the service account listed as an editor
Troubleshooting
Data not syncing to sheets
- • Verify the service account email is added as an editor
- • Check that Sheet IDs are correctly entered (no extra spaces)
- • Ensure sheets are not deleted or moved to trash
- • Try removing and re-adding the service account
Permission denied errors
- • Make sure the service account has "Editor" permissions, not "Viewer"
- • Check if the sheet is in a shared drive (may need additional permissions)
- • Verify you're using the correct service account email
Next Steps
Now that your Google Sheets are connected, set up Google Calendar for complete integration:
Google Calendar Setup