Skip to content
  • Google Sheets logoGoogle Sheets logo
  • Pardot logoPardot logo

Google Sheets + Pardot

Add new Pardot prospects to multiple rows in Google Sheets

Stay organized and efficient with this workflow that takes prospective clients from Pardot and instantly adds them to your Google Sheets document. When you add a new prospect to a list in Pardot, the automation promptly populates multiple rows in a Google Sheets spreadsheet with the prospect's details. This ensures you always have up-to-date information, helping you keep track of and manage your prospects better, and saving you the hassle of manual entry.

Stay organized and efficient with this workflow that takes prospective clients from Pardot and instantly adds them to your Google Sheets document. When you add a new prospect to a list in Pardot, the automation promptly populates multiple rows in a Google Sheets spreadsheet with the prospect's details. This ensures you always have up-to-date information, helping you keep track of and manage your prospects better, and saving you the hassle of manual entry.

  1. When this happens...
    PardotPardot
    Prospect Added to List

    Triggers when a Prospect is added to a list.

    TriggerPolling
  2. automatically do this!
    Google SheetsGoogle Sheets
    Create Multiple Spreadsheet Rows

    Create one or more new rows in a specific spreadsheet (with line item support).

    ActionWrite
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

    • ListRequired

    Trigger
    Polling
    Try It
    • ListRequired

    • ProspectRequired

    Action
    Write
    • ListRequired

    • ProspectRequired

    Action
    Write
  • Pardot triggers, actions, and search

    New or Updated Prospect

    Triggers when a Prospect is created or updated in Pardot.

    Trigger
    Polling
    Try It
    • Email AddressRequired

    • First Name

    • Last Name

    • Last Activity At

    • Salutation

    • Campaign

    • Address One

    • Address Two

    • City

    • Zip

    • State

    • Territory

    • Country

    • Website

    • Phone

    • Fax

    • Job Title

    • Department

    • Company

    • Number of Employees

    • Years in Business

    • Industry

    • Notes

    • Comments

    • Source

    • Score

    • Password

    • Account

    • Annual Revenue

    • Is Do Not Email

    • Is Reviewed

    • Is Starred

    • Is Do Not Call

    Action
    Write
    • NameRequired

    • CampaignRequired

    • ListsRequired

    • From NameRequired

    • From EmailRequired

    • Subject LineRequired

    • Email Body (Text)Required

    • Email Body (HTML)

    • Tags

    • Custom Reply-To Address

    • Suppression Lists

    • Scheduled Time

    Action
    Write
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Related categories

pardot logo
pardot logo

About Pardot

Pardot is no-hassle marketing automation that makes sales and marketing teams best friends. Increase marketing accountability, gain greater insight into ROI, and much more.

Related categories

Triggers & Actions