Add Slack messages to Google Sheets

What’s it handy for?

Being able to send a message in Slack to any other app is really quite powerful. In this case with Zapier, it’s possible to push the text of any message in Slack to a new row in a Google Sheet. 

Use Zapier to push messages into Google Sheets to:

  • Compile a list of volunteers that respond in a channel
  • Save “best of” messages to a file you can use later
  • Assemble a new hire handbook filled with the best advice from current employees

Before you get started

Sign up for an account at Zapier and configure it to connect with your Slack workspace. Create a new sheet at Google Spreadsheets with the first row set aside as titles for your data columns.

How to automatically add slack messages to Google Sheets

  1. Create a new Zap for Slack that triggers from a New Pushed Message on Zapier.com.
    Creating a new Zap in Zapier
  2. Add an action to your Zap for Google Sheets. Select Create Spreadsheet Row.
    Selecting Google Sheets create row action in Zapier
  3. Pick your target spreadsheet and specific sheet. Customize the data and columns you want to match in your spreadsheet. In this case, it’s the author username, time/date it was posted, and the contents of their Slack message.
    Picking content matching from Slack to Google Sheets in Zapier
  4. Save your Zap and publish it so it is live.
  5. Now that your Zap is live, switch back into Slack. Use the message action menu on a Slack message you want to save in the spreadsheet.
  6. Choose the zap you want to launch.
    Choose the Zap you'd like to launch from within Slack
  7. Zapier will automatically send the message to your Google sheet according to the fields you configured.

Was this tip useful?

0/600

훌륭해요!

피드백을 주셔서 감사합니다.

알겠습니다!

피드백을 주셔서 감사합니다.

죄송합니다. 문제가 발생했습니다. 나중에 다시 시도해주세요.