Google BigQuery + Pardot

Create rows in Google BigQuery for new form submissions in Pardot

Save time by seamlessly gathering response data from new entries filled out in Pardot and storing them conveniently in Google BigQuery. This efficient workflow eliminates the need for manual data entry, helping you focus more on valuable data analysis and insights. The updated process ensures an easy and rapid organization of form data, leading to a more streamlined statistical study of your collected information.

When this happens...
New Form SubmissionTriggers when a form is submitted.
TriggerPolling
automatically do this!
Create RowsCreates new rows of data in a table (accepts line items). Note: Does not create a job.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Pardot and Google BigQuery

Discover other triggers and actions you can use with Pardot and Google BigQuery

New Form Submission
Triggers when a form is submitted.
Trigger
Polling
Try It
- List
  Required
Trigger
Polling
Try It
- List
  Required
- Prospect
  Required
Action
Write
- List
  Required
- Prospect
  Required
Action
Write
- Prospect
  Required
- Email Address
- First Name
- Last Name
- 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
- Do Not Email?
- Review Status
- Star Status
- Do Not Call?
Action
Write

- Email Address
  Required
Action
Search
- Project
  Required
- Dataset
- Table
Trigger
Polling
Try It

- Project ID
  Required
- Job ID
  Required
- Location
  Required
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
Action
Write
- Project ID
  Required
- SQL Query
  Required
- Location
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Action
Search

New Prospect
Triggers when a new Prospect is synced to Pardot.
Trigger
Polling
Try It
New or Updated Prospect
Triggers when a Prospect is created or updated in Pardot.
Trigger
Polling
Try It
- Email Address
  Required
- 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
- Name
  Required
- Campaign
  Required
- Lists
  Required
- From Name
  Required
- From Email
  Required
- Subject Line
  Required
- Email Body (Text)
  Required
- Email Body (HTML)
- Tags
- Custom Reply-To Address
- Suppression Lists
- Scheduled Time
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Email Address
  Required
- 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
Search or write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Unique Column
  Required
Trigger
Polling
Try It
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- IS Operator
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Rows
  Required
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
- Update Columns
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search
- Project
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search or write

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Learn moreLearn moreHelpHelp

Related categories

Databases

Google

Premium

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.

Learn moreLearn moreHelpHelp

Related categories

Marketing Automation

Premium

Similar apps

HubSpot

Marketing Automation

Intercom

Customer Support

Autopilot Journeys

Marketing Automation