Until today, the first step in connecting Google Sheet to Abacum was often met with a frustrating "Google blocked this access" or "Unverified app" warning. These alerts could create additional friction with your IT and Security teams.

But this has changed: We have completed Google’s formal certification. You will no longer see scary red warning screens when connecting your spreadsheets.

✨ What’s new?

• Official Google verification: No more "Unverified App" warnings.
• Multiple account support: You can now connect and manage more than one Google account within your Abacum workspace.
• Dataset oversight: A new "Info" action on your connection card allows you to review exactly which datasets are linked to a specific Google account at any time.
• Additional security checkpoints: To maintain the highest security standards, you will be prompted to briefly re-authenticate when creating a new dataset or exporting data to Google Sheets

💡Best practice: Usage of a central account

To ensure your data remains stable even as your team changes, we highly recommend using a central or service account (e.g., [email protected]) rather than an individual user's email.

• Maintain continuity: Always select your organization's central account when prompted to re-authenticate during dataset creation or model exports.
• Avoid data gaps: Using a central account prevents "orphaned" datasets – connections that break if a specific team member leaves the company.
• Full visibility: You can always check which account is powering a specific dataset in the "Accounts info" section of your Google Sheets card.

⚙️ How to get started

The new integration flow is automatically enabled for newly created organizations. For existing workspaces, it is being rolled out gradually to ensure a smooth transition. If you would like to activate it sooner, please contact your Customer Success Manager or the Abacum Support team. Once enabled, the setup process is simple:

1. Re-authenticate Click “Re-authenticate” on the Google Sheets card in the Integrations menu.

2. Trigger the migration for existing datasets: To ensure previously connected datasets continue working under the new verified integration:

   • Start creating a new dataset.
   • Open the Google Sheets file picker.
   • Select any existing spreadsheet (this can be done multiple times if needed).
   • As soon as the picker is opened and a file is selected, Abacum will register access to that spreadsheet and automatically migrate the existing datasets to the new connection.
     You do not need to finish creating the dataset. Simply opening the picker and selecting a file is enough to activate the new integration and ensure previously connected datasets keep working.
3. Create new datasets or export data: From now on, when creating a new dataset or exporting data from a model, Abacum may ask you to briefly re-authenticate your Google account to confirm the secure connection.