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?
Best answer by XRay Tech
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.