Best answer

How can I tell Zapier to use the first worksheet in a Google Sheet without the name?

Userlevel 1

Hi!

I’m automating a process that involves a Table in Excel(.xlsx)

Once i’ve copeid that into Drive and converted to .gsheet i just can’t retrieve any row because the worksheet name is different every time

How i just can tell the zap to use the first worksheet without the name??

Please help.

icon

Best answer by Troy Tessalone 3 October 2023, 22:19

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

Userlevel 7

+14

Hi @greenhub

Good question.

If there are multiple worksheets, then you’ll have to add logic to isolate the first worksheet ID.

Userlevel 1

Hi @greenhub

Good question.

If there are multiple worksheets, then you’ll have to add logic to isolate the first worksheet ID.

Thanks for your response Troy!

Ok, but if tehre’s only one Worksheet in the SpreadSheet, I need to use the API or there’s another way?

Userlevel 7

+14

@greenhub

If the Worksheet title and Worksheet ID are different each time, then yes you will need to use the GSheets API.

Sign up