SheetsDB

    Sheet access

    Supported Google Sheet links

    SheetsDB accepts shared Google Sheet URLs, published-to-web URLs, and spreadsheet IDs. Private Sheets are not supported.

    By Zainul Ariffin

    Shared URL

    In Google Sheets, open Share and set General access to Anyone with the link, with Viewer permission.

    Supported URL
    https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit?usp=sharing

    Published URL

    Use File, Share, Publish to web when you want Google to serve a published copy.

    Supported URL
    https://docs.google.com/spreadsheets/d/e/PUBLICATION_ID/pubhtml

    Spreadsheet ID

    The ID is the value between /d/ and the next slash in a standard Sheet URL.

    Supported value
    1AbCdeFgHiJkLmNoPqRsTuVwXyZ123456789

    Private Sheets cannot be read

    SheetsDB does not request access to your Google Drive. A Sheet that requires a signed-in viewer returns SHEET_UNAVAILABLE.