Syncing with Google Sheets

Questions
1

i’m trying to use the google sheets, integration. Part of it is mapping the various columns, but the node isn’t letting me do that. When I go to map manually, it says: No columns found in Google Sheets. Retry. Retrying doesn’t help. it’s simply not reading the columns I have put into google sheets ( yes I have refreshed).
Any ideas? Thanks so much!!

image
image1270×1094 69.3 KB

2

I think you have to reconnect your OAuth2 credentials.

Then try again.

3

Thank you. Do i need to share all edit permissions? I’ve been trying to avoid that and only sharing documents as needed

4

Go to Credentials(next to workflows), check your Google credential for Sheet, and reconnect (click again on the blue Google), I think token expired if your app isn’t published.

5

thanks, i’ve done that. It still isnt working i’m afraid

6

Ok… you self host the n8n? Or cloud option?

7

Try to re-select the document and sheet and see if the column show up.

Just checking your column is in the first row right?

8

Was it working before or this is your first time doing it ?

  • if it was working before, please try to create new credentials and do the authentication again

  • if it’s the first time doing it, I think you are not giving the appropriate permissions, please take a look at this video: https://www.youtube.com/watch?v=FBGtpWMTppw

9

No, it was never working. I use the cloud option. I’m a first time user, have managed to navigate well so far with help of AI but this one is tricky because there’s no option to map to columns and when I change columns in spreadsheet it doesn’t seem to be receiving that data

10

Thanks. When i go to create a new credential this URL isn’t available. See screenshots (first is from video, second is what I’m seeing when creating a new credential)

:

image

image
image2024×1254 155 KB

11

Ok so Claude is telling me the reason I don’t see the URL is “Your using OAuth2 (recommended) which handles everything automatically - you don’t need to manually set up Google Cloud!”

12

You have to set the webhook url (not the https://localhost , you will need a public URL not localhost with your n8n instance), in the google account.

Then, yes you can click that oauth2 button.

13

Thanks, I’ve sorted this part out but now have a broader blocker. Will set up a separate thread

14

Can you share how did you solve it ? and also can you mark your reply as the answer ? so people who face (or will face) the same problem can see how did you solve it.

Thanks!

15

Hi @Lawyerandfounder

Here are the most likely solutions to fix the “No columns found” error:

  • Add a Header Row: Ensure the very first row in your “Sheet 1” contains titles for each column. This is the most common cause of this error.

  • Refresh the Schema: After adding headers, click the “Retry” link. You may also need to re-select the specific sheet from the dropdown menu to force the tool to check for the columns again.

  • Check Permissions: Try re-authenticating your Google Sheets account within the tool. The connection might have expired or lack the necessary permissions to read the sheet structure.

  • Verify the Correct Sheet: Double-check that your data and header row are in the exact document (“Chatbot Query Log v3”) and sheet (“Sheet 1”) selected in the node.

    If my reply is helpful, kindly click like and mark it as an accepted solution.
    Thanks!