Skip to main content
Question

Add Prospect to list in Pardot Zap

  • February 18, 2023
  • 1 reply
  • 126 views

Abstract

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

Problem:

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.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • February 18, 2023

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.