n8n

How to Capture Slack Ideas in Google Sheets Tracker?

Turn Slack ideas into a clean list without copy and paste. Team members use a simple slash command to send ideas. Each entry lands in Google Sheets with the author’s name so reviews are fast and organized.

A webhook receives the Slack command. A setup node stores your Google Sheets link, and a switch routes the request so you can add more commands later. The Google Sheets node writes a new row with the idea text and the Slack username. After saving, an HTTP request posts back to Slack using the response URL to thank the sender and prompt for extra details.

Setup needs a Slack app with a slash command and a Google Sheet with Name and Creator columns. Expect fewer missed ideas and less manual work, cutting collection time from hours each week to minutes. Useful for product teams gathering feature ideas, support teams logging bugs, and sales teams tracking customer asks.

What are the key features?

  • Webhook captures Slack slash command posts and parses the payload
  • Setup node stores the Google Sheets URL so you can change sheets without edits elsewhere
  • Switch routes requests and leaves room to add commands like bug or pain
  • Google Sheets append or update adds Name and Creator with user entered formatting
  • HTTP request sends a confirmation message back to Slack using the response URL
  • Sticky notes in the canvas provide clear setup guidance

What are the benefits?

  • Reduce manual copy and paste from 1 hour per week to 5 minutes
  • Streamline idea collection by 80 percent with one Slack command
  • Improve data quality by 90 percent with standard fields
  • Connect Slack and Google Sheets seamlessly
  • Handle 5 times more submissions without extra admin work
  • Give instant feedback in Slack to close the loop with the sender

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Google Sheets and Slack. See the Tools Required section above for links to create accounts with these services.
  3. In Google Sheets, create a spreadsheet with two columns named Name and Creator. Keep the sheet on the first tab for a simple start and copy the spreadsheet URL.
  4. In n8n, open the Set me up node and paste your Google Sheets URL into the Google Sheets URL field. Save the node.
  5. Open the Add to Google Sheets node. In the Credential to connect with menu, click Create new credential and follow the on screen steps to connect your Google account. Name the credential clearly such as Google Sheets Prod.
  6. Open the Webhook node and copy the Test URL. Leave the workflow open so it can listen for the test request.
  7. In your Slack app settings, add the chat write scope, create a slash command named /idea, and set the Request URL to the Webhook Test URL you copied. Install the app to your workspace.
  8. In Slack, run /idea followed by sample text. Check that a new row appears in your sheet with the idea and creator. Confirm that Slack shows a thank you message.
  9. Open the Switch node and confirm the rule routes the idea command. To support more commands later, add new outputs and match on different command values.
  10. Back in the Webhook node, copy the Production URL. In the Slack slash command settings, replace the Request URL with the Production URL and save.
  11. Activate the workflow in n8n. Run another /idea test to verify data still arrives and Slack gets the confirmation message.
  12. Troubleshooting: If rows do not appear, recheck Google Sheets credentials and that the sheet tab is the first one. If Slack errors, confirm the Request URL is correct and the method is POST. Make sure the command text is not empty.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

Slack

Sign up

Free plan: $0 / mo; limited to 10 apps (third-party or custom) and usable via Slack API

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.