google-sheets-json-webhook-receiver

KO | EN

gitlite — search

#javascript #hacktoberfest #golang #android #linux #nodejs #macos #java #windows #vue #security #pytorch #mcp #openai

google-sheets-json-webhook-receiver

(★ 26)

Google Apps Script that appends a JSON object to a spreadsheet as columns

google-sheets-json-webhook-receiver Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# google sheets / slack json webhook receiver

Google Apps Script that appends a JSON object to a Google Sheets spreadsheet as columns, suitable for use as a [formsort](https://formsort.com) webhook integration.

Also allows setting a Slack webhook to be pinged when receiving a result.

## features

- runs entirely within your Google Apps domain
- automatically creates new columns if new data fields appear in the JSON body
- always adds a `received_at` column to mark when data was received by the script

## setup

0. Make a new Google Sheet you want to use for your answers. Keep it blank.
1. Go to https://script.google.com and create a new script.
2. Paste the `Code.gs` in this respository into the `Code.gs` of that project
3. Update the `SPREADSHEET_URL` variable at the top with the URL of your spreadsheet. If you'd like a slack webhook to be pinged when the webhook is processed, enabled the [Incoming Webhooks App](https://api.slack.com/incoming-webhooks) on slack and then replace SLACK_URL with the webhook URL. If you're not using one or another, set it to `null`;
4. Debug the script, to ensure it's connected, by clicking `Debug` in the toolbar with the `test` function selected. You should see a row added to the output.
5. Publish the script, using `Deploy > New deployment`, with the following settings:
      - Type: **Web app**
      - Execute as: **Me**
      - Who has access: **Anyone** (Don't worry, the URL is unique and only you will have it.)
6. Copy the **web app URL**, which starts with `https://script.google.com` and ends with `/exec`, to Formsort's webhook url in the integrations section.
7. To test the configuration end-to-end, use the *Send test webhook* button.
8. Deploy any variants in the flow that you'd like to start using this.
9. You do not need to update the spreadsheet or script settings when you change the flows - columns will automatically be added or removed as needed.

google-sheets-json-webhook-receiver

google-sheets-json-webhook-receiver Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

google-sheets-json-webhook-receiver

google-sheets-json-webhook-receiver Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README