> For the complete documentation index, see [llms.txt](https://docs.pagerly.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pagerly.io/sync-pagerduty-opsgenie-oncall-schedule/sync-schedule-from-tools-pagerduty-opsgenie-datadog-etc/find-sheet-id-from-google-sheets.md).

# Find Your Google Sheets Spreadsheet ID

Find your Google Sheets spreadsheet ID in the sheet URL, between /d/ and /edit, and use it to connect the sheet to Pagerly in Slack.

Pagerly needs the spreadsheet ID to read your Google Sheet. The ID is part of the sheet's URL, between `/d/` and `/edit`.

## Find the spreadsheet ID

1. Open the Google Sheet in your browser.
2. Look at the address bar. The URL looks like this:\
   `https://docs.google.com/spreadsheets/d/`**`1AbCdEfGhIjKlMnOpQrStUvWxYz0123456789`**`/edit#gid=0`
3. Copy the part between `/d/` and `/edit`. That string is the spreadsheet ID.

<figure><img src="https://296040630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fu15pukNExHWOsjYrdZrh%2Fuploads%2F26efLTtWL4hmBXoM0Jpm%2Fimage.png?alt=media&amp;token=030b0793-b59d-4892-a8ae-868d8acab95b" alt="Google Sheets URL with the spreadsheet ID between /d/ and /edit"><figcaption></figcaption></figure>

## Spreadsheet ID vs sheet ID (gid)

The number after `#gid=` at the end of the URL is the ID of one tab inside the spreadsheet, not the spreadsheet itself. Pagerly needs the spreadsheet ID, so don't paste the `gid` value. Google describes both IDs in its [Google Sheets API concepts](https://developers.google.com/sheets/api/guides/concepts) guide.

## Next step

Paste the spreadsheet ID into Pagerly, then go to **Setup Team Access** to finish connecting the sheet.
