Best answer

Slack Messages to Spreadsheets, but column by column

  • 10 April 2021
  • 1 reply
  • 10 views

Userlevel 1

Hello,

I recently created a Zap that connects Slack messages to Google Spreadsheets. Messages come from bots in Slack, and there are different data parts. In Zapier, I can define what data parts should be taken and added to a row in Google Spreadsheets. However, all the data units are added into one column when adding. I want them to be added in the new row but I want them in separate columns instead of one column.

Does anybody know how to solve this issue?

icon

Best answer by XRay Tech 11 April 2021, 01:02

Hey @sambrown 

Try adding additional column headers to your gsheet. If columns A:C all have headers, then you will have 3 fields to choose from inside of Zapier when you ‘Refresh Fields’ on that specific Zapier step. 

Generally, I’d recommend moving to Airtable over google sheets. Its a much more ‘future proof’ solution, and will make things easier as they get more complicated with multiple zaps.

Goodluck! 👋

View original

1 reply

Badge +2

Hey @sambrown 

Try adding additional column headers to your gsheet. If columns A:C all have headers, then you will have 3 fields to choose from inside of Zapier when you ‘Refresh Fields’ on that specific Zapier step. 

Generally, I’d recommend moving to Airtable over google sheets. Its a much more ‘future proof’ solution, and will make things easier as they get more complicated with multiple zaps.

Goodluck! 👋

Reply