Integrations

    How to connect a Google Sheet

    With the Google Sheets connection, generated leads are appended to your spreadsheet row by row — your team keeps working in the tool they already use.

    5 min read

    Prepare the spreadsheet

    Steps

    1. 1Create a new spreadsheet in Google Sheets (or use an existing one).
    2. 2Name the tab where leads should land, e.g. "Scalino Leads".
    3. 3Copy the URL from the address bar. It looks like https://docs.google.com/spreadsheets/d/…

    Grant Scalino write access

    Steps

    1. 1In the Scalino automation form, open the "Google Sheets" section and copy the service account email shown there.
    2. 2In Google Sheets click "Share" in the top right.
    3. 3Paste the email and set its role to "Editor".
    4. 4Turn off the notification option and click "Send".
    5. 5Paste the spreadsheet URL back into the Scalino form.

    Choosing the tab

    Once the URL is entered, Scalino lists the tabs in the spreadsheet. Pick the one leads should go to; if you skip it, the first tab is used.

    If tabs do not appear, click "Refresh tabs" — the sharing permission usually just needs a moment.

    Which columns are written

    If the sheet is empty Scalino creates the header row. Existing rows are never overwritten — each lead is appended.

    • Business name
    • Address
    • Phone
    • Website
    • Google rating
    • Opening hours
    • Generated date

    Manual sync

    If you added the sheet after the automation was created, push earlier leads with "Sync to Sheet". Use "Edit sheet connection" to change the target later.

    Frequently asked questions

    I get an "access denied" error.

    Make sure the service account email is added as an Editor. Viewer access is not enough for writing.

    My URL is rejected even though it looks valid.

    It must start with docs.google.com/spreadsheets/d/. Shortened links or share links copied from the mobile app may not work.

    Will my formulas break?

    No. Scalino only appends rows to the selected tab; formulas and pivots on other tabs are untouched.

    Related guides