Sending Slack Form Responses to Google Sheet via Zapier


Zapier is an automation tool that connects over 3,000+ apps together.

The Forms for Slack Zapier integration takes advantage of Zapier's "Triggers". Any time a form response is submitted, we send that response to any Zaps you have created, including the Form response data. 

    In this example we'll show you how you could send new Form responses to Google Sheets!

    Create your form

    For best results, make sure to give your form a title. If you're not sure how to create a form you read this guide.

    screenshot create your form in slack

    Connect your Form to Zapier

    Read our guide on connecting Forms to Zapier if you haven't connected already. here we're using the workflow creator on Zapier's dashboard to get started quickly. 

    connect to zapier

     

    Connect your Forms app if you haven't already  

    You'll need to copy in your API key from Slack. Don't worry, it takes 30 seconds and if you're not sure you can read our guide here.

    slack forms zapier api key generation

     

    Select your Form

    This is the Form that will trigger your Zap. Anytime a response is submitted to this form it will trigger this Zap.

     

    Follow the prompts to connect Google Sheets

    Choose your Google Drive account, Spreadsheet and tab.

     

    Map your Form responses

    Now the fun part! You can map the titles and Form responses to Google sheet columns. Here's how everything maps over for my "Feedback" form. 

    forms for slack to google sheet zapier mapping screenshot 

    In my example, I want to include the form title, and the response that the user submitted in the "User Response" form field.

    google forms slack zapier screenshot successful

     

    Test and turn on!

    When you're ready, you can test your Zap and switch it on. Your form responses will now flow through to Google Sheets!

    Here it is in action: