Google Sheets Zap cannot find the worksheet - both custom and static values don't work

Hi ​@ClayPotter 

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

GSheets API docs: https://developers.google.com/workspace/sheets/api/reference/rest

Here's the Zapier community post that might help: 

Hope this helps you get it sorted! And let me know how it goes — happy to dig deeper if needed!

And if you'd rather just get it sorted quickly, I offer a free 20-min Zapier troubleshooting call. Book it under Resources on my Zapier Directory profile: https://zapier.com/partnerdirectory/automatemybiz!-->

Thank you both ​@Troy Tessalone and ​@Fahad S. 

“Get Spreadhseet by ID” is the method that I should have examined earlier -- that checked all the boxes for my requirement.

Although, it is unintuitive, redundant and wasteful of task count, when - 1. “New File In Folder” gives you an ID and the mime type of google sheet already, it’s hard to imagine why you have to (once again) “Get” the spreadsheet by ID! Anyhow, for now I am set. 

The link to Google API docs was helpful (and it’s good to know what is possible via raw API calls), but I think a native way to create a workflow is preferable from sustainability perspective. Thank you.

P.S. I read the linked discussion and it seems to be dated -- that discussion concludes that API call is the only way, and turns out this is wrong. Or is there any specific situation when that is true? Based on what I saw in my tests, it looks like it would get me a good deal of metadata about the sheet. 

Also, a follow-up question, since we are discussing dealing with Google Sheets with unknown format: I have a scenario with sheets, where some columns (e.g. First Name, Last Name) are present, but some other columns (e.g. photo permission, dietary restrictions) not always present in the export -- depending on whether that data was collected or not. 

An ugly way is to expect a human to edit the sheet first and “canonize” it to a required format (e.g. canonized format is columns A, B, C, D, E and a sheet with only columns A,D,E can be canonized manually by inserting columns B,C in the specific order to make the column list canonized to A,B,C,D,E.) But I am looking for a better, more “automated” option.

This column list should ideally contain the first row (header) turned into a list, on which one could iterate. 

I believe Python code can do this, but I am searching if a more “ready” action etc. are available.

Using this method, it may be possible to identify missing and available columns, and then take it from there (this is the hope!)

TIA!! 

​@ClayPotter 

For this: I believe Python code can do this, but I am searching if a more “ready” action etc. are available.

There is not a more “ready” action available for that type of logic.

Custom logic generally requires custom code, custom AI, and custom API requests.

BACKGROUND

Action: GDrive - New File in Folder

GDrive is an app for files/folders.

Returns data about the file and folder, not the file/folder contents.

Action: GSheets - Get Spreadsheet by ID

GSheet is an app for spreadsheets.

Returns data about the file contents.

» Returns data about the file contents.

Actually, returns basic metadata as well (as in the get Spreadsheet by ID action, where it returns #of columns and #of rows.) -- Also the actions pretty much “mandate” the first row being a header row (rightly so) -- therefore this is not really custom logic. Anyway. Thank you for confirmation.