Best answer

Creating multiple columns in Google Sheets when creating a new row triggered from Slack?

  • 1 October 2020
  • 2 replies
  • 809 views

Userlevel 1

I have a created a Zap that triggers when a certain reaction is added to a Slack message. This then creates a row in a Google Sheet worksheet.
So far, so good, and it works.

However, Slack messages can be messy and noisy, and I want to help the person reading the new row by adding more context, such as link to Slack message, name of user, etc,

When adding that however, all information ends up in one cell. Whereas I want to add all these elements in separate columns.

Any thoughts on how to do that? I can’t see how to ‘hack’ in the set-up (see attached screenshot). I added ; as that is the delineator in a CSV file, but that didn’t work either.

 

 

icon

Best answer by adamsmartschan 1 October 2020, 15:11

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 5
Badge +6

@PeterSterkenburgBrella -

Add the columns to your sheet and refresh in Zapier. They should appears as fillable fields in your Action step.

Userlevel 1

Fantastic, that works. Thank you!