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.
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.
Every time a new row is added to your Google Sheets spreadsheet, Make will automatically create a new contact in ActiveTrail. The template uses this example spreadsheet.
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 there is a new post in Canny, Make will automatically create a new row in your Google Sheets spreadsheet. The template uses this example spreadsheet.
This template shows how you can take advantage of Make to train your MonkeyLearn model easily. Every time a new row is added to your Google Sheets spreadsheet, Make will automatically upload the data to your MonkeyLearn classifier. The template uses this example spreadsheet.
Every time when you get a new response at Wootric, Make will automatically add information about responses to your Google Sheets spreadsheet as a new row. The template uses this example spreadsheet.
This template periodically checks for new rows in a Google Sheets spreadsheet and uploads the new rows as new contacts into Endorsal.
The template is using this sample Google Sheets spreadsheet - you can make a copy of it if you'd like to.
The template is scheduled to run daily at 8:00 am. You can change the schedule after you set up the template.
This template adds a new row into a Google Sheets spreadsheet as soon as a new survey response is collected by Refiner.
While setting up the template, you need to take a generated webhook URL from Make and use it in Integrations>Webhooks in the Refiner UI.
The template expects your Refiner survey to have these questions:
- How disappointed would you be if you could no longer use our service?
- NPS score
The template saves the responses to this sample Google Sheets spreadsheet. You can make a copy of it for testing purposes.
Note that email values from Refiner will only be passed to Google Sheets if they are available for the particular survey submission.
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.
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