Add a Google Sheets connection

Connect your Google Sheets to Equals

Jiayan Yu avatar
Written by Jiayan Yu
Updated over a week ago

To connect to your Google Sheets as a datasource in Equals, first ensure that you have permission to view the Google Sheets workbook you would like to connect, and check that it is properly formatted.

  • There should be a single row of headers at the top

  • Only raw values will be carried over into Equals, not formulas or formats. You can re-apply your formats from Equals.

Once your Google Sheet is properly formatted, you’ll just need your Google Sheets URL to connect to it as a datasource in Equals.

  1. From your Google Sheets workbook, select Share from the top right corner, and then Copy link.

  2. Go to the datasource page in Equals and select Google Sheets. Follow the prompt to connect your Google account.

  3. Paste your Google Sheets URL into the Workbook URL field

  4. Select Test & Create.

Now, you can bring your Google Sheets data into Equals using the query builder. Pair with live data from any source to catch issues and spot opportunities that much faster.

Did this answer your question?