How to retrieve the value from a particular Google Sheet cell

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

Page 1 / 1

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.

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.

Hopefully, this helps!

@Edmund Lam

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

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded