Google Form responses in Slack
Every new Google Form response is posted to a Slack channel.
How it works
Trigger: Google Sheets — new row in the form's response sheet
- Watch the sheet linked to your Google Form.
- Format each answer as a line: question — answer.
- Post it to your Slack channel.
Diagram
Trigger App Code
Code
JavaScript used in the Code step — already included in the template below.
// Mode: Run Once for Each Item
// Turns a form response row into readable "question — answer" lines.
const lines = Object.entries($json)
.filter(([key, value]) => key !== "row_number" && value !== "")
.map(([question, answer]) => `*${question}*\n${answer}`);
return { json: { text: `📝 New form response\n\n${lines.join("\n\n")}` } };Build it
Pick your tool — same automation, step by step.
Copy and paste straight into an n8n canvas (Ctrl+V), or download and use Import from File. Then connect your own credentials and replace every YOUR_… placeholder.
Show code (117 lines)
{
"name": "Google Form responses in Slack (Flowngn)",
"nodes": [
{
"parameters": {
"content": "## Google Form responses in Slack\nEvery new Google Form response is posted to a Slack channel.\n\n**Setup**\n1. Open each node and connect your own credentials.\n2. Replace every YOUR_… placeholder.\n3. Test once, then activate.\n\nFree template from Flowngn",
"height": 260,
"width": 340
},
"id": "26068bc2-eac9-4e99-a8cb-b57353c0b957",
"name": "Setup notes",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-420,
-60
]
},
{
"parameters": {
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"documentId": {
"__rl": true,
"value": "YOUR_SPREADSHEET_ID",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "Form Responses 1",
"mode": "name"
},
"event": "rowAdded",
"options": {}
},
"id": "26068bc2-eac9-4e99-a8cb-b57353c0b957",
"name": "New response",
"type": "n8n-nodes-base.googleSheetsTrigger",
"typeVersion": 1,
"position": [
0,
0
]
},
{
"parameters": {
"jsCode": "// Mode: Run Once for Each Item\n// Turns a form response row into readable \"question — answer\" lines.\nconst lines = Object.entries($json)\n .filter(([key, value]) => key !== \"row_number\" && value !== \"\")\n .map(([question, answer]) => `*${question}*\\n${answer}`);\n\nreturn { json: { text: `📝 New form response\\n\\n${lines.join(\"\\n\\n\")}` } };",
"mode": "runOnceForEachItem"
},
"id": "26068bc2-eac9-4e99-a8cb-b57353c0b957",
"name": "Format answers",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
300,
0
]
},
{
"parameters": {
"select": "channel",
"channelId": {
"__rl": true,
"value": "#requests",
"mode": "name"
},
"text": "={{ $json.text }}",
"otherOptions": {}
},
"id": "26068bc2-eac9-4e99-a8cb-b57353c0b957",
"name": "Post to #requests",
"type": "n8n-nodes-base.slack",
"typeVersion": 2.2,
"position": [
600,
0
]
}
],
"connections": {
"New response": {
"main": [
[
{
"node": "Format answers",
"type": "main",
"index": 0
}
]
]
},
"Format answers": {
"main": [
[
{
"node": "Post to #requests",
"type": "main",
"index": 0
}
]
]
}
},
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"meta": {
"templateCredsSetupCompleted": false
},
"tags": []
}In Make, create a new scenario and add these modules in order:
- Google Sheets › Watch New Rows
- Tools › Set variable / Iterator + Array aggregator (same logic as the Code step)
- Slack › Create a Message
- Every module run uses Make operations — the free plan includes a monthly quota.
- Make's built-in functions (map, sum, formatDate…) can replace most Code steps; for complex logic use a code module.
- Module and step names can differ slightly as Make and Zapier update their apps.
In Zapier, create a new Zap and add these steps in order:
- Google Sheets — New Spreadsheet Row
- Code by Zapier — Run JavaScript (paste the code from the Code section)
- Slack — Send Channel Message
- Zaps with more than two steps need a paid Zapier plan.
- Webhooks, Filters/Paths and Code by Zapier are premium features on some Zapier plans.
- Code by Zapier runs JavaScript: reuse the code shown above, reading inputs from inputData instead of $json.
- Module and step names can differ slightly as Make and Zapier update their apps.
Tips
- In Google Forms: Responses → Link to Sheets to create the sheet.
Related flows
ProductivityEasy
Job applications → sheet + team ping
Every application from your form is logged in a hiring sheet and shared with the team.
Typeform → Google Sheets → Slack4h/mo
ProductivityEasy
Tasks due today reminder from Notion
Get a Slack message listing every Notion task due today.
Notion → Slack2h/mo
ProductivityEasy
Daily standup prompt in Slack
Every weekday morning, post the standup questions so the team answers in a thread.
Slack8h/mo