Google Sheets (OAuth)

Connect FactBranch to your Google Sheets account using OAuth to securely access your spreadsheets without sharing passwords. This authentication method provides read-only access to your Google Sheets data.

Once you've connected your Google account, the authentication is stored securely on FactBranch's servers and can be reused across multiple nodes and flows.

In this article you'll learn:

What you can access

With Google Sheets OAuth authentication, FactBranch can:

• Read spreadsheet data - Access cell values, formulas, and formatting
• List your spreadsheets - Browse spreadsheets you have access to
• Access shared spreadsheets - Read spreadsheets shared with your account

Permissions granted: Read-only access to your Google Sheets.

Setting up Google Sheets OAuth

To create a Google Sheets OAuth authentication in FactBranch:

1. Go to your Data Sources dashboard
2. Click Add data source
3. Select Google Sheets
4. You'll be redirected to Google's authorization page

Google authorization process

When you click to connect Google Sheets, you'll be taken to Google's secure authorization page where you can:

1. Choose your Google account - Select which Google account to connect
2. Review permissions - See exactly what FactBranch can access
3. Grant access - Authorize FactBranch to read your spreadsheets

Google will then redirect you back to FactBranch.

Using the authentication

Once connected, you can use this authentication in:

• Google Sheets nodes - Load data from your spreadsheets
• REST API nodes - Make custom requests to the Google Sheets API

To use the authentication in a node:

1. Create or edit a Google Sheets node in your Flow
2. Go to the Authentication tab
3. Select your Google Sheets authentication
4. The node will now have access to your spreadsheets

Managing your connection

Renaming the authentication

To rename your Google Sheets authentication, click Rename next to the title or double-click the title itself. Enter the new name and press Enter to save.

Revoking access

If you need to disconnect FactBranch from your Google account:

1. Go to your Google Account permissions
2. Find "FactBranch" in the list of connected apps
3. Click Remove access

You can also delete the authentication from your FactBranch Data Sources dashboard.

Troubleshooting

"Access denied" errors

If you get access denied errors: - Check that the spreadsheet is accessible with your Google account - Verify the spreadsheet URL is correct - Make sure the spreadsheet isn't restricted to specific users

"Authentication expired" errors

OAuth tokens can expire. If this happens: - FactBranch will automatically attempt to refresh the token - If refresh fails, you may need to reconnect your Google account - Go to your Data Sources and reconnect the Google Sheets authentication

Spreadsheet not found

If a spreadsheet can't be found: - Ensure you have at least view access to the spreadsheet - Check that the spreadsheet hasn't been deleted or moved - Verify you're using the correct Google account

Permission issues

If you can't access certain spreadsheets: - The spreadsheet owner may need to share it with your Google account - Check if your organization has restrictions on external app access - Verify the spreadsheet is in Google Sheets format (not Excel or other formats)

Security and privacy

• FactBranch only requests read-only access to your spreadsheets
• Your Google password is never shared with or stored by FactBranch
• Access tokens are stored in a database that is encrypted at rest
• You can revoke access at any time through your Google Account settings or by deleting the authentication in FactBranch.