Add Prospect to list in Pardot Zap

  • 18 February 2023
  • 1 reply

What I would like to accomplish with Zap:

  1. Take new Google Sheet data and import it to Pardot list via Zap 
  2. I would like to add any new contacts/rows to a Pardot list from Google Sheets.

What I did in Zap:

  1. I’ve set up a Zap trigger New Spreadsheet Row in Google Sheets. to export data from Google Sheets.
  2. From Google Sheets, I set up a find prospect in Pardot action to look for a contact based on Google Sheet email data. 
  3. Then another action to Add Prospects to Pardot list


I was able to set up everything up, but when I got to Add Prospect to List in Pardot, I could only select one Prospect in the step details. That essentially only allows for a single record updated in the Pardot list selected. It’s not adding new records/rows from the Google Sheets as they come in.


Do I need to set up a custom action to look for a specific field or…? Please help. 

The name of the Zap is Google Sheet to Pardot List in my Zap. Thank you.

1 reply

Userlevel 7
Badge +14

Hi @Abstract 

Good question.

For us to have context, please post detailed screenshots with how your Zap steps are configured, thanks.

Make sure to use variables mapped between Zap steps to make the Zap dynamic.