Pull Sheet Rows based on Range of Date (dynamic)

Userlevel 1

Objective: Send weekly slack message containing the sheets contents of that week puling from the “date” column. 

Example: See image below


My zap will be a weekly scheduled trigger. I would like to be able to input the row into the slack message based on the current date range. I would prefer to remain in google sheets and not transfer to airtable. I am comfortable formatting the slack message, I just need to be able to have the correct rows as input. 

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

4 replies

Userlevel 7
Badge +14

Hi @jessie8o8 

Good question.

Try adding another column to the GSheet that uses a formula function to get the week number for the date.

Then use can use the GSheets Lookup Row(s) action to search by the week number, thus achieving a dynamic range to return the matching rows.

Userlevel 6
Badge +8

I like Troy’s idea of adding a week number column…

I have a similar Zap I use, but it’s a daily one, so I have a calculated column in the Google Sheet where the date is formatted exactly the way I’ll want my Zapier search to look for it.

The Zapier search/action I use for that is “Lookup Spreadsheet Rows (output as Line Items)” and it works great

Userlevel 1

I am a novice in sheets. How do I make a column that populates based on the date? Especially in units of weeks

Userlevel 7
Badge +9

Hey there, @jessie8o8! Found a few resources here that might be useful:

I hope some of this helps! 🧡