How to Connect Amalgam to Google Drive

Connect Google Drive to Amalgam to have scheduled reports delivered straight into a Drive folder or Google Sheet. Google Drive is a destination, not a data source: it does not add reports, it gives your Routines somewhere to put them. Google Drive connects by signing in with your Google account and approving the connection. The Google Drive integration is in beta.

What You Need

• A Google account that can edit the Drive folder or Google Sheet you want reports delivered to.
• An Amalgam account with access to Routines.

Connect Google Drive

1. Log in at app.amalgam.me.
2. Click New Integration and choose Google Drive. You can type “Drive” in the search box to find it.
3. Amalgam sends you to Google’s sign-in page. Pick the Google account, or sign in to it.
4. Review the permissions Amalgam asks for. If Google shows checkboxes, tick them all, then click Allow or Continue. Google sends you back to Amalgam with the integration ready to use.

What You Can Do With It

When you create or edit a routine, choose the Google Drive integration as the delivery destination. Each run can land as a new file in a folder, or replace a tab in an existing Google Sheet. See How to Schedule a Report with Routines.

Troubleshooting

• The routine fails to deliver: the Google account that connected Drive no longer has edit access to the folder or sheet. Share it with that account again, or reconnect with a different account.
• Google blocks the app: your Google Workspace administrator restricts third-party apps, or has Drive set to block untrusted 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.