Create new rows in Google BigQuery from new Refiner survey submissions
About
This template creates new rows in a Google BigQuery table based on new Refiner survey submissions.
The template expects your Refiner survey to have these questions:
- How likely are you to recommend our service a friend or colleague? (as an NPS score question)
- What do you value you most about our service? (as an open question)
- How many starts would you give us? (as a star rating question)
The template also expects your destination BigQuery table to have these columns:
received_atas datetimenpsas integerstartsas integerwhat_do_you_valueas string
Note that email values from Refiner will only be passed to BigQuery if they are available for the particular survey submission.
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.
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.
Every time a new customer review is added to your Google Sheets spreadsheet, Make will automatically analyze its sentiment (positive or negative) with a MonkeyLearn machine learning model. The template uses this example spreadsheet.
Every time you receive a new response in the CommCare account, Make will automatically add selected data from the response to a new row in a Google Sheets spreadsheet. The template uses this example spreadsheet.
Every time a new review is added to your Judge.me, Make will automatically add it to your Google Sheets as a row. Here's the worksheet used in this scenario.
This template periodically checks for new rows in a Google Sheets spreadsheet and uses the retrieved information to create new customers in LiveAgent.
The template is using this sample Google Sheets spreadsheet as a source of the data. You should make a copy of it before configuring the template.
The template is scheduled to run every 15 minutes. You can change the schedule after you set up the template.
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.
Creates a new dataset.
Creates a new, empty table in the dataset.
Deletes the dataset specified by ID.
Deletes the table specified by ID.
Returns the dataset specified by dataset ID.
Gets the specified table resource by table ID.
Creates a new user in Refiner or updates an already existing user.
Lists all contacts.
Lists all datasets in the specified project to which the user has been granted the READER dataset role.
FAQ
How Make works
Thousands of fast-scaling businesses create and automate on Make
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."
"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."
"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."
"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."