Searching Columns in Google Sheets

Hi ​@teamX 

Why not structure the GSheet columns like this: 
Col A | Col B | Col C
Date | Time | Value

That way each combo of a Date + Time is it’s own row that you can search for. 

Hi ​@Troy Tessalone - I thought about that, but I realised then that it would create 34 timeslots per day - which would add up quickly. I intend to use this sheet as a frontend to see at a glance which timeslots have been booked - so doing it this way would make it a hassle for someone to scroll to their date since there would be (34 x 5 x 10 = 17000) rows to skim through. Is there no other way to search it in its current configuration?

​@teamX 
Instead of using GSheets, consider using Airtable.
Airtable has Table Views, which are segments of data. (sort, filter, group, show/hide fields, reorder fields)
NOTE: This approach would require an Airtable paid plan for that many records.

​@teamX 

Otherwise, you have to use the GSheets API: https://developers.google.com/workspace/sheets/api/guides/concepts

Zap action: GSheets - API Request

Help links for using GSheets in Zaps: https://zapier.com/apps/google-sheets/integrations#help

​@Troy Tessalone 

I won’t be able to purchase any plans, and I’m also using google sheets as it was one of my client’s requests. Would there be any code workaround or obscure action that might be able to fix this issue? I am also open to reordering the information as long as it does not make it a hassle to search for the information (As that is the purpose of the sheet)

​@teamX 

It would require a custom solution involving the GSheets API and possibly custom Code to be able to query for a column, derive the row/column, then update the cell.

Try asking ChatGPT for help.

Otherwise, you have to use the GSheets API: https://developers.google.com/workspace/sheets/api/guides/concepts

Zap action: GSheets - API Request

 

Help links for using GSheets in Zaps: https://zapier.com/apps/google-sheets/integrations#help

Alright, I’ll check that out. Thanks for the help!

​@teamX 

You may want to look into using Filter Views
https://support.google.com/docs/answer/3540681?hl=en&co=GENIE.Platform%3DDesktop

NOTES:

• GSheets in Zaps can be fragile if humans are actively touching the worksheet data.
• Changes they make on purpose or accidentally can break the Zap
   

Hey ​@teamX, just checking in—were you able to get this sorted? 

Keep us posted on your progress, want to make sure you’re all set! 🙂