The new Google Sheets webhook allows you to create a new line in a Google Sheets file, automatically and with each new answer collected by MyFeelBack!

So, use the raw customer answers available in your Google Sheets file to:

  • Viewing data in Google Data Studio
  • Share raw answers with your employees
  • Power your third-party web applications connected to Google

__________________________________________________________________

The following articles will help you throughout the configuration:
 

Set up a webhook using the Google Sheets template
Go to Settings > Webhooks > Google Sheets

Click on Integrate

In the URL field, indicate the Spreadsheet_Id, as indicated:
https://sheets.googleapis.com/v4/spreadsheets/[#spreadsheet_Id]/values/Sheet1!A1:append?valueInputOption=RAW
You can find it in the URL of your GSheet file:

For more information about Spreadsheet_Id, see this page.

Choose an OAuth Authentication

__________________________________________________________________

You don't have authentication?

To create a new authentication, enter the items listed below:

To generate your identifiers (Client id and Secret),

  • Then activate Google Sheets API
  • Retrieve the codes provided

You can insert the values generated above in the corresponding fields.

Then, indicate the rest of the requested information (Authorization url, Token url and Authorization parameters).

__________________________________________________________________

Continue configuration

Once your authentication has been created and selected, you can customize the content of your webhook.

We have added by default the values [#feedback.id], [#campaign.name] and [#answer], but you can modify these values with those that best suit your needs. To learn how to use variables, see the dedicated article (in french).

These values correspond to the information that will be added to each column of your Google Sheets file. Feel free to add new ones if necessary.

__________________________________________________________________

Use the webhook

To trigger your webhook and feed your Google Sheets file, configure your Webhook post-answer action. Learn more about webhooks

Select the Google Sheets webhook and indicate the value of the variables used

Check that your trigger criteria match your needs.
For more details about configuring an action, please read the dedicated article

Your action is well configured and your webhook is ready to be triggered!

__________________________________________________________________

Example of adding data to a Google Sheets file:

__________________________________________________________________

Want to try it? Click here 👇

Avez-vous trouvé votre réponse?