Hi there!
Would appreciate assistance from the community as am currently working on my Zapier workflow and got stuck.
I'm currently working on an automated email which is sent to customers each time google forms is completed.
The email would also contain a 6 digit code for the customer to use.
While i have already configured the python code on google sheets, am unable to match the email which only sends the code to the customer’s respective row.
Ie customer 1, row G2 alpha numeric code
customer 2, row G3 alpha numeric code
customer 3, row G4 alpha numeric code
etc etc
how do you update lookup row for google sheets in Zapier that it will only send the column G alpha numeric (code) ie G2, G3, G4 respectively?