How to Connect Amalgam to Google BigQuery

Connect Google BigQuery to Amalgam to run queries against your BigQuery data from your spreadsheets, Claude or ChatGPT. BigQuery connects by signing in with your Google account and approving the connection. The access Amalgam gets is whatever your Google account has in BigQuery.

What You Need

• A Google account with access to the BigQuery project. On the project it needs the BigQuery Job User role (or BigQuery User) to run queries, plus BigQuery Data Viewer on the datasets or tables you want to read. One role alone is not enough.
• An Amalgam account.

If you are not sure which roles you have, ask the owner of the Google Cloud project. Google’s guide: BigQuery access control.

Connect Google BigQuery

1. Log in at app.amalgam.me.
2. Click New Integration and choose Google BigQuery. You can type “BigQuery” in the search box to find it.
3. Amalgam sends you to Google’s sign-in page. Pick the Google account that has BigQuery access, or sign in to it.
4. Review the permissions Amalgam asks for and click Allow. Google sends you back to Amalgam with the integration ready to use.

What You Can Pull

The Base Query Report runs a query against your BigQuery project. See Reports by Provider.

Troubleshooting

• “Access Denied” or “Permission denied” when running a report: the Google account is missing one of the two roles above on the project or dataset. Ask the project owner to add it.
• Google blocks the app: your Google Workspace administrator restricts third-party apps. They can allow Amalgam in the Admin console under Security, then Access and data control, then API controls.
• Removing access from the Google side: go to myaccount.google.com/permissions, find Amalgam and remove it.