What are you trying to achieve?
Hi everyone,
I’m trying to automate a process where Zoho Form submissions update a Google Sheet. I have a sheet with employee names in columns A and B, and dates as headers in columns C onwards. When an employee submits a form, I want to mark the corresponding date cell in their row with a “1”.
I am having issues doing this as I am new to Make. I tried it with Zapier and it seems impossible on there due to not being able to grab columns. Attached is a photo of how I would like it.
Scenario:
Ideally John Smith would submit his form on Zoho. Process on Make would take the first name and last name and match it. Then it would find the match of the cell where it connects with the date from the form submission. Once that cell is found, then we would insert a 1 which is to make the cell green as they have submitted the form on this date.
Steps taken so far
I have already tried get cell and search rows and am not sure how to go about this.
Attached is how I would like it to be setup. If form submitted input 1, otherwise input 2.
