Create BigQuery tables from new Google Form responses

Get this template

Get this template

Apps used in template

Google Forms

BigQuery

About

Every time a new response is entered on your Google Form, Make will automatically create a table with the related data in BigQuery.

Trusted by thousands of fast-scaling organizations around the globe

Similar templates for inspiration

Looking to get more out of your apps? With Make, you can visually integrate any app into any workflow to save time and resources - no coding required. Try any of these templates in just a few clicks.

Export BigQuery Tables to Google Sheets

This template helps you export a BigQuery table to Google Sheets. The scenario can be set up to run at regular intervals (every hour, day, week or a specific date).

Try It ➔

Add new incoming survey from Survey123 to a Google Sheets spreadsheet as a new row

Every time you receive a new survey, Make will automatically add selected data from the survey123 to a new row in a Google Sheets spreadsheet.

This template is expecting these columns in your target Google Sheet:

ID
Object ID
Name
Phone number
Email address

It's OK if your spreadsheet does not have exactly matching columns. You will just map your survey response items to your columns.

Try It ➔

Save new Tripetto entries to a Google Sheets spreadsheet

Every time someone fills out your Tripetto form, Make will automatically add the submission to a new row in a Google Sheets spreadsheet.

Try It ➔

Upsert a vector into a Pinecone namespace from new Google Sheets row data

Easily upsert vectors into Pinecone namespaces using Google Sheets row data, enhancing search and machine learning capabilities, improving data-driven insights and decision-making.

Try It ➔

Send Paperform submissions to a Google Sheets spreadsheet

Any new Paperform submissions will add a new row to a Google Sheets spreadsheet.

Try It ➔

Export Firestore documents to Google Sheets

This Template helps you export a collection of Firestore documents to Google Sheets. Make will automatically save all document field values in a new spreadsheet row. This scenario uses this example spreadsheet. Prerequisite: This template can't save fields of Array, Map or Geo type.

Try It ➔

Add Google Sheets rows for new Tally responses

Make will watch your Tally responses at regular intervals and add them to your Google Sheets as rows. Here's the sheet used in this scenario.

Try It ➔

Create a QuestionPro survey for a new Google Sheets row

Every time a new row is added to the Google Sheets spreadsheet, Make will automatically create a QuestionPro survey.

Try It ➔

Add new Kizeo Forms users to a Google Sheets spreadsheet as a new rows

Every time a new user is created in Kizeo Forms, Make will automatically add that person to a new row in your Google Sheets spreadsheet. The template uses this example spreadsheet.

Try It ➔

Create your own workflow

Create custom workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.

Add a Response in Google Sheets

Appends a new response to the bottom of the Google Sheets table.

Action

Create a Dataset

Creates a new dataset.

Action

Create a Form

Creates a new form.

Action

Create a Table

Creates a new, empty table in the dataset.

Action

Delete a Dataset

Deletes the dataset specified by ID.

Action

Delete a Response in Google Sheets

Deletes a specific response from the bottom of the Google Sheets table.

Action

Delete a Table

Deletes the table specified by ID.

Action

Get a Dataset

Returns the dataset specified by dataset ID.

Action

Get a Form

Retrieves an existing form by its ID.

Action

FAQ

How do I get started with Make?

What is a scenario?

What is a module?

What is mapping?

How Make works

Thousands of fast-scaling businesses create and automate on Make

See Make in action

See how Make works

Trusted by 500,000+ Makers

"Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."

Philipp Weidenbach

Head of Operations at Teleclinic

"Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."

Cayden Phipps

COO at Shop Accelerator Martech

"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."

Erkki Markus

Product Owner at Smaily

"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."

Andreas Wixler

CTO & Co-founder at FINN