Reconnect forms to Google Drive in Squarespace

All forms in Squarespace that use Google Drive must be re-uploaded before September 23, 2024. If not, you may lose important data.

Many websites use forms to collect data, such as contact forms or newsletter subscriptions. You can choose to link these forms to Google Drive. The advantage of this is that the information is then stored in a spreadsheet (Google Sheet) so that it is easy to retrieve later.

Due to changes at Google in September 2024, all such forms that store answers in Google Drive must be reconnected. This must happen before September 23. If not, Google Drive will stop receiving submissions from the forms.

Please note that everyone this applies to should have received an email from Squarespace with information in late August/early September. If you have not received an email, it does not apply to you.

This is how you do it:

Do you prefer video? See explanation from Squarespace here:

Step 1 - Connect from Google Drive

The first thing you need to do is connect from Google Drive:

1. Log in to your Google Drive account.

2. Click on the gear icon in the top right corner and select "Settings" in the drop-down menu.

3. Click on "Manage Apps".

4. Scroll down to "Squarespace" and click on "Options".

5. Select "Disconnect from Drive" in the drop-down menu. This will remove Google Drive from all forms associated with this Google account.

You only need to do this once.

Step 2 - Reconnect to the form

Contact form and/or newsletter subscription form:

1. Log in to Squarespace, go to "Pages". Find the right page in the overview and click "Edit".

2. Double-click on the form that has a link to Google Drive. Select "Storage" > "Google Drive". Click "Disconnect" and then "Disconnect" again to confirm.

3. Click "Connect" next to "Google Drive". Follow the steps to sign in and connect to Google Drive.

4. Enter a name for the new spreadsheet you want to save submissions in. It is not possible to use an existing spreadsheet.

Repeat these steps for all forms on the page and on all pages that have such forms.

Form in a pop-up:

1. Log in to Squarespace, go to "Marketing" > "Marketing Tools" > "Promotional Pop-up"

2. Select "Action" in the left panel, click the "Storage" tab and select "Connect other services" to see Google Drive.

3. Select "Google Drive", click "Disconnect" and then "Disconnect" again to confirm.

4. Click "Connect" next to "Google Drive". Follow the steps to sign in and connect to Google Drive.

5. Enter a name for the new spreadsheet you want to save submissions in. It is not possible to use an existing spreadsheet.

Repeat these steps for all forms on the page and on all pages that have such forms.

Step 3 - Submit a test

We recommend submitting a test form to make sure everything is working properly.

Frequently asked questions

• Who is responsible for this?

  This applies to anyone who has linked a form in Squarespace to a spreadsheet in Google Drive.

• Does this apply to storage options other than Google Drive?

  No, the changes at Google only affect forms that use Google Drive as a storage option.

• Will I lose submissions that have been saved from before?

  No, submissions you have saved from before will not be deleted. But it is important that you reconnect the form to Google Drive before September 23, 2024 to avoid missing out on new submissions. They will not be saved unless you update the link.

• Are new submissions stored in a new spreadsheet?

  Right. When you reconnect, enter a new name for a new spreadsheet that is automatically created in Google Drive. A new spreadsheet will be created even if you enter the same name as your previous document.