How do I set a dynamic Lookup Value in Google Sheets to automate Pinterest pin creation?

  • 21 October 2023
  • 1 reply

Hi guys, 

I’m new to automation and Zapier. 

I’m trying to automate pin creation for Pinterest.

I pulled in 2 columns from Google Sheets, 1 has links to photos on Drive, the other has texts for overlay » both of these are sent to Placid where they are populated in an existing design I created » From there I get a download link that I want to send back to the Sheets and place on the column to the right of the values I extracted from there.

I managed to go through quite a few errors with the help of Chat GPT, but I came across something it doesn’t seem to solve - My issue is that I don’t understand how to pass the Lookup Value part, I’m trying to set a dynamic value there, but I can’t understand how to do it. 

I recorded a quick Loom, and I’d love your help!

Thank you very much.



1 reply

Userlevel 7
Badge +14

Hi @pazitive 

Good question.

You likely don’t need step 3.

Instead, map the Row/ID from Step 1 to Step 4.



FYI: It’s spelled Zapier with 1 P.