Hi Zapier Community!
I’m trying to create a zap that works when there’s no activity in an account for example on social media or other apps for 4 days.
How can I create it? I know I have to use google sheets as a middle process but I don’t know how.
Thanks for the help!
I’d recommend using Airtable instead of GSheets.
Airtable has Table Views.
Views have Filters. (e.g. Last Updated > 4 days ago)
Views can be used to trigger Zaps.
You’ll need to configure Zaps to log the app activity that you are monitoring in the Airtable Base Table: https://zapier.com/apps/airtable/integrations#triggers-and-actions
You’ll need to configure other Zaps that trigger from the Airtable Views.
If you need help, consider hiring a Zapier Expert: https://zapier.com/experts
Troy thanks for your answer!
Could you specify more the process or the zaps to create?
Personally, I would do this with Google Sheets and you would need a couple of Zaps to do it. The first Zap triggers from the social media event (eg new tweet) and sends it to the Google Sheet. The Zap will need to add the date (or date and time, depending on how specific you want to be) to the sheet.
For the second Zap:
Now you’ll know how many days between the Zap firing each day and the day of the last social media post!
Then you can you add whatever step you want on the end of the Zap to alert you that there’s been more than 4 days between social media posts (eg send an email/slack message/text/etc).
Hey Danvers! I did it and it worked!
Thank you so much,