A Zapier zap that takes each new form submission, posts a notification to Slack, and adds a row to a Google Sheet. Keep the team informed and the data logged in one step.
{
"version": "1.0",
"platform": "zapier",
"title": "Form Response to Slack + Google Sheet",
"steps": [
{
"id": 1,
"type": "trigger",
"app": "Google Forms",
"event": "New Form Response",
"config": {
"form": "Contact Form"
}
},
{
"id": 2,
"type": "action",
"app": "Slack",
"event": "Send Channel Message",
"config": {
"channel": "#leads",
"message": "New lead: {{1.name}} ({{1.email}})"
}
},
{
"id": 3,
"type": "action",
"app": "Google Sheets",
"event": "Create Spreadsheet Row",
"config": {
"spreadsheet": "Leads",
"worksheet": "Sheet1",
"row": {
"Name": "{{1.name}}",
"Email": "{{1.email}}"
}
}
}
]
}