Skip to main content
Question

How do I automate bi-weekly Slack updates from Google Sheets data using Zapier?

  • December 4, 2024
  • 2 replies
  • 39 views

Hi Everyone,

I'm hitting a wall on a zapier automation and would greatly appreciate some expert assistance here.

Here’s what I’m trying to accomplish:

I want to send bi-weekly automated Slack updates to individual slack channels based on data stored in a Google Sheet.
My current table has the following fields: Project NameSlack Channel ID, a boolean to determine whether a bi-weekly update should be sent, and around 8-10 other fields that I’d like to include in my automated messages.I’ve successfully created a Zap for an individual row in the sheet, but I’m struggling to iterate over all rows and filter the automation based on my boolean.

Does this sound familiar to anyone? Any expert tips to share in terms of action sequencing ?

thank you so much !

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

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

Hi ​@johans 

Try these Zap steps...


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • December 9, 2024

Hello there, ​@johans! 👋

How did you get on with those Google Sheets and Looping actions Troy suggested here—did they do the trick? 

If you’re still stuck or have any questions at all please do let us know!