Question

How to retrieve the value from a particular Google Sheet cell

  • 15 September 2023
  • 4 replies
  • 509 views

I want to know whether the following scenario can be created in a zap. I cannot figure out how to create zap steps to perform #3-5 below:

1. Check whether a given Google Drive's folder has a new Google Sheet.

2. If none, the zap can end.

3. If yes, open it and search whether cell C1 (always the same cell location although it is a different file each time) has a value.

4. If C1 is empty, do nothing. Go to Step 6.

5. If C1 is filled, copy it and paste it into cell D1 in another Google Sheet (it is always the same file).

6. Once done, move the Google Sheet located in step 3 to another designated folder.

 

Thank you,

Edmund


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

4 replies

Userlevel 7
Badge +14

Hi @Edmund Lam 

Good question.

Can you post a screenshot with the top few rows of the GSheet so we can have a better understanding of how the GSheet is structured?

Hi @Troy Tessalone,

 

Thanks for your quick reply. I want to extract the values from these 5 cells highlighted in yellow and add them to a new row in another Google Sheet.

 

 

Userlevel 7
Badge +6

Hi there @Edmund Lam,

I’m jumping in to see if I can help!

You might need to redo the headers of your spreadsheet. Google Sheets needs to get set up in a specific way for the Zap to interact with your sheet effectively.

You can read more on how to setup your spreadsheet here: https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps#make-sure-the-first-row-is-a-header-row-with-column-names-0-0

Hopefully, this helps! 😊

Userlevel 7
Badge +14

@Edmund Lam 

This can be done using the GSheets API: https://developers.google.com/sheets/api/reference/rest