Skip to main content

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?

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! 👋