Skip to main content

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

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

@Goyalaviral 

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


@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) 


@Goyalaviral 

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


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


@Goyalaviral 

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