I’m trying to get zapier to send slack messages based on the date/column in excel. The excel sheet is updated daily and I want zapier to send slack messages for each row with a particular date or date range
Best answer
How to send multiple rows from Excel to Slack
Best answer by Troy Tessalone
Hi
Good question.
The Excel Find Row Zap action will only return 1 row.
GSheets has 2 Zap actions that will return multiple records (MAX 10 or 20)
Otherwise, you can use an Airtable Base with the Airtable API to return multiple records.
NOTE: The Airtable API has pagination that returns 100 records per page.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
- Answer
Hi
Good question.
The Excel Find Row Zap action will only return 1 row.
GSheets has 2 Zap actions that will return multiple records (MAX 10 or 20)
Otherwise, you can use an Airtable Base with the Airtable API to return multiple records.
NOTE: The Airtable API has pagination that returns 100 records per page.
+14- Zapier Orchestrator & Solution Partner
Yes and no.
With GSheets, depends on how the data is structured.
You may need to use another GSheet tab with formulas to dynamically query for the desired date range.
The Airtable API has a filterByFormula parameter...
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.