Reading a cell in a row, based on the value decide on an outcome, and replace the value in the cell with a boolean

I have been able to extract all the info I need and interact with GForm to collect data and upload it to an Excel spreadsheet.
Now I need to read each row for one cell named status.
If the cell is empty, as it is when I upload a new row, I check with some module for a case, if possible I need to write yes, if not, write no. As long as there are blank cells for status in a row, I will perform this action.
each time a new row is updated, I check for this value which starts blank then process and update it.

I have not found documentation clear enough on GSheet to understand how to target read and update one cell, is anyone able to point out some literature on this?


i found a fair amount of information in the help files and it is clearer than what i saw last time. I will try solving this over the week and report my solution or confirm i need more help. Thanks a lot
In the meantime i found the Make Add-on which i also was missing so progressing

1 Like

If you want to learn more about Make, you can read up in the Help Center. I also recommend doing the tutorials in the Make Academy, and learn advanced skills like how to make custom apps to any API in the Make Partner Training Portal - both have certificates for successful completion.

If you need further assistance,

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters. It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

(Note: Exporting your scenario will not include private information or keys to your connections)

Uploading it here will look like this:

blueprint.json (12.3 KB)