How to connect Google Sheets to your form

Integrating Google Sheets with Formaloo allows you to automatically transfer form responses to a Google Sheet, making data management easier.

Follow these simple steps to connect Google Sheets to your form:

Step 1: Access the App Store

Log in to your Formaloo account.
In the dashboard, click on the profile icon located at the top-right corner.
From the dropdown menu, select App Store.

In the App Store, find and click on Google Sheets.
A new popup will appear, presenting three tabs:
- Description: Provides details about what the integration does.
- Add new integration: This is where you can set up a new connection.
- Active integrations: Manage existing connections here (edit, delete, or resync).

6. Click on the Active Integrations tab and resync your data.

If you’ve previously set up integrations, you can view and manage them in the Active Integrations tab.
Here, you can:
- Edit: Update settings or change the linked form or sheet.
- Delete: Remove the integration if it's no longer needed.
- Resync: Manually synchronize the data between the form and the Google Sheet.

⭐ Pro tip:

To connect your form to Google Sheets, make sure to:

You're the owner of the formaloo, which means you must have created the formaloo with your current account. Only the user who has created a formaloo can connect it to third-party tools.
The Google account you connected to your Formaloo workspace has sufficient access to the Google Sheets you're trying to connect to here.
You provided all requested access levels when connecting your Google Sheets.

If you haven't provided necessary access while connecting your Google account, follow these steps:

Open your profile settings and disconnect your Google account.
Then go back to the same page. On this page, click the Connect Google button.
Sign in to your Google account and make sure to mark all checkboxes to provide Formaloo access to edit your Google Sheets and sync your data.
Connect your Sheet with your formaloo by providing the Sheet name and URL. Make sure the title of the Sheet and its link match the Sheet you want to be synced with your formaloo data.

For a seamless, real-time connection between your Google Sheets and Formaloo form, consider enabling Two-Way Sync.

This feature automatically updates data in both systems, helping you manage responses effortlessly.
Learn how to set up Two-Way Sync here.

⭐ Pro tip:

Remember when you are adding your Google Sheet, the sheet title is at the bottom of the page, and you should use the related sheet URL.

For example, if you want to change sheet 2 to sheet 1, the title and URL of the sheet will be different and should be changed.

🗄️ Old dashboard:

To connect your Google Sheet to your form on the old dashboard, right-click on your form and select “view responses.

Go to the “Integration & Webhook” tab, and select “Connect to Google Sheets”.

Now, enter the sheet name and URL of the same sheet.

Your form is connected to your Google Sheet and it syncs the responses automatically from your form.