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.