Skip to main content

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?

Hi @spirou 

Good question.

Please post screenshots with how your Zap steps are configured along with screenshots with how your GSheet is configured.


Here some screenshots


@spirou 

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


@spirou 

Can you post screenshots with how your GSheet is configured?


@spirou 

You may want to reference this article: