Skip to main content
Question

How to trigger Zap at 10PM to log Slack channel messages in Google Sheets?

  • August 30, 2024
  • 6 replies
  • 31 views

I wanted to set a trigger as the EOD 10PM to run a zap where all the messages that has been sent in a specific Slack Channel (raw text, file URL) and updated in the google sheet.

 

Let’s say, at EOD there are 30 messages containing the text and a file, all 30 messages data should be updated in 30 rows in google sheets

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

6 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • August 30, 2024

Hi @Goyalaviral 

Steps

  1. Trigger: Schedule - Daily
  2. Action: Slack - API Request
    1. Likely have to use the Slack API to get all messages in a Channel for a datetime range
  3. Action: GSheets - Create Row(s)
    1. Supports line items

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • August 30, 2024

@Goyalaviral 

Another approach might be to try using a Digest: https://zapier.com/apps/digest/help


  • Author
  • New
  • August 30, 2024

@Troy Tessalone Thank you for the inputs.

But are these possible in the free version of Zapier? Since, I prefer to use the free version for now, wondering if you could suggest some possible ways in that.

(Got a limit of 100 task execution per month, while my requirement is of 1000 data entries per month. I thought having it run everyday would work) 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • August 30, 2024

@Goyalaviral 

Zaps with 3+ steps require a Zapier paid plan to turn ON.


  • Author
  • New
  • August 30, 2024

@Troy Tessalone No other way to do this in two steps?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • August 30, 2024

@Goyalaviral 

Not that I’m aware of based on your requirements and conditions.