Hello Zapier community,
I’m facing an issue:
The zap i’ll try to create is this one:
When there is a sale on systeme.io, update column A with email customer from the sale on the google sheet dynamicly (meaning always on the next raw) then assign a code which is in column C and same raw as the column A to finaly send it by email.
The issue i’m facing is the dynamic part, or it always used the same raw or facing an issue with adding a lookup step.
Can someone help me on that?
+14
Hi
Good question.
Please post screenshots with how your Zap steps are configured along with screenshots with how your GSheet is configured.
Here some screenshots
+14
In Step 2, you need to map a Lookup Value for the Lookup Column from Step 1.
In Step 3, you need to map the Row/ID from Step 2.
Can you give more details about step 2.
Step 1: the trigger is a sale
so what would be lookup column and value for step 2? As column i can select column from my spreadsheet but as value i can only select value from system such as email adress from the buyer
+14
Can you post screenshots with how your GSheet is configured?
+14
You may want to reference this article:
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
