Clay Icon
Join the Community
02 Support

Need Help Connecting Google Sheets to a List

Avatar of BrayanBrayan
·
·

Hi team I want to connect a google sheet to a list but when I put the link of the sheet it doesn't let me save it, I'm an editor can you please help? Thanks

18 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To connect a Google Sheet to a Clay list, follow these steps: 1. Make sure you're on Clay's Starter plan ($149/mo) or higher, as the Google Sheets integration isn't available on the free plan. 2. Go to your Clay table and click "Add Enrichment". 3. Search for "Google Sheets" and select the appropriate action (e.g., "Add Row"). 4. Click "Add Account" and sign into your Google account. 5. Name your account and click "Save". 6. Paste your Google Sheets URL. 7. Select the sheet name and map the relevant columns. 8. Click "Save". If you're still having trouble saving the link, double-check that you have the correct permissions on the Google Sheet. If the issue persists, you may need to request human assistance for further troubleshooting.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·
  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hi Brayan, Looks like everything is working on my end. Can you let me know what other trouble you're having? Let me know if you need more help!

    (3691 kB)
    Image
  • Avatar of Brayan
    Brayan
    ·
    ·

    Hi team I added the sheet but when i run it it doesnt export to the sheet, am i doing something wrong?

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey Brayan - I don't see this in the table you sent. Can you make sure to select a sheet, then add the values to the respective rows and run the enrichment again? I don't see this when I go in your table (see gif)?

    (4192 kB)
    Image
  • Avatar of Brayan
    Brayan
    ·
    ·

    but it shows an error

  • Avatar of Brayan
    Brayan
    ·
    ·
  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey Brayan,

    Now if you click on the error, you will see the reason why. If we check it's saying: No values in the header row - fill the first row with header values before trying to interact with rows.

    Can you do so?

  • Avatar of Brayan
    Brayan
    ·
    ·

    What are header values

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Great question. Those are the values you add in the first row of the Google Sheet. They will be considered the header for all the following rows. See the gif for how to add them (name1, name2). Then you'll be able to go back to the Google Sheet integration in Clay, refresh the fields, and you'll see those values appear. You can then add the values from Clay you want in those rows with the forward slash.

    (803 kB)
    Image
  • Avatar of Brayan
    Brayan
    ·
    ·

    Thanks for the clarification I’ve added the Header values but nothing comes up so you know why ? Thanks for your help

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    You need to click on the company name, press forward slash, and then select the value you want to add - See here :)

    (2649 kB)
    Image
  • Avatar of Brayan
    Brayan
    ·
    ·

    It finally worked! Man thank you I’ve been dealing with this all week hahaha thank you thank you !!!

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Great! Keep us posted if you need anything else. Would love to help! :)

  • Avatar of Brayan
    Brayan
    ·
    ·

    Sound good thank you!