Skip to main content
Question

Help with Slack to Google Sheets Zap

  • September 3, 2020
  • 2 replies
  • 65 views

Hi there! 

 

I’m hoping somebody can help me build my ideal scenario: 

 

Ideal Workflow:

 

In Slack, I reply with an emoji, which creates a Google Sheet Spreadsheet titled the name of the channel.

 

Later in the Slack channel, If I react with a different emoji, it adds that Slack message as a row in that Google Sheet Spreadsheet.

 

The Issue:

 

On paper, this seems like an easy Zap, but I’m hitting bumps.

 

Specifically, because I can’t have two triggers in one Zap, my Zap is having a hard time finding the new google sheet.

 

Anybody have any advice?

Did this topic help you find an answer to your question?
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

jpot
Forum|alt.badge.img+5
  • Zapier Staff
  • 55 replies
  • September 3, 2020

Hello! My name is Justin and I work for the Zapier blog. 

I gave this a shot and had trouble getting it to work. The problem: Google Sheets doesn’t have a search step for finding a particular spreadsheet, and you can’t just use the “custom” step. I can’t really picture a way to make this work, because of that. The only thing I can think to do is to make the spreadsheets myself, then set up Paths for each channel to spreadsheet workflow. Which isn’t nearly as slick as what you're imaging, I know. Sorry about that. Maybe someone else will think of something? 


AndrewJDavison_Luhhu
Forum|alt.badge.img+10

Hi @egolden 

Just checking back in. Did you manage to work something out here?