Skip to main content
Use this integration to turn a Google Sheets range into a Dawn dataset. You need a Google account that can read the spreadsheet.

​
Permissions

Dawn requests https://www.googleapis.com/auth/spreadsheets.readonly and offline access so scheduled work can refresh authorisation without requiring you to sign in for every run. It does not request a Sheets write scope in this flow. The OAuth scope covers spreadsheet read access available to the authorised account. The spreadsheet URL in your Dawn connection selects what to use; it does not narrow the scope of the Google authorisation. See Google’s scope reference.

​
Set up the connection

  1. Open Connections → New connection.
  2. Select Google Sheets and enter a descriptive name.
  3. Paste the Spreadsheet URL or ID.
  4. Use Authorize account, sign in to the appropriate Google account, and review the consent screen. Alternatively, select an existing Google Sheets credential.
  5. Save the connection.
If your Google Workspace organisation restricts third-party apps, an administrator may need to allow the authorisation.

​
Choose the data to import

Set the import’s sheet range using A1 notation, for example Sales!A1:F5000 or 'Monthly Sales'!A:F. Include the header row. If the range is left blank, the connector uses the first worksheet. The first row of the returned range becomes the column names. Subsequent rows become data records. Use a consistent table rather than merged cells or several unrelated tables on one sheet.
After running the import, check the number of rows, headers, date values, and totals. A range ending at row 5000 will omit later rows; choose the range deliberately as the sheet grows.

​
Refresh and disconnect

Run the import again to read updated values. Configure a repeatable pipeline when you need scheduled refreshes. Changes to the source sheet do not automatically update a previously imported dataset. To change accounts, authorise a new credential and select it in the connection. To revoke access, remove the app’s access in Google and disable the Dawn connection. Previously imported data remains in Dawn.

​
Troubleshooting