Question

Scheduling Email Reports Based on Google Sheets Cells

  • 16 March 2022
  • 3 replies
  • 50 views

I want to send myself a weekly report (email) based on a true false column in my sheet. I want to have anyone whose last appointment is within the next 2 weeks put in this report so i can make communicating with them easier

I want it to trigger on a Monday at 6am

loop through the sheet and pull all of the true rows into an email to me with the data from the customers

 


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

3 replies

Userlevel 7
Badge +14

Hi @MattATSoCalYouthSports 

Good question.

I highly recommend using Airtable instead of GSheets for this: https://zapier.com/apps/airtable/integrations

Airtable has Views.

Views have Filters. (e.g. Date = Today)

Views can be used to trigger Zaps.

Airtable has internal Automation capabilities.

Airtable has an API that can be leveraged.

is there a way of automatically update the airtable form either my booking software (amelia) or when i pull data into a sheet of every booking, for airtable to upload it automatically, find the last appointment booking date and then create automation t send me a report when that persons last appointment falls within certain parameters?

 

----------------------here is what i have------------------

Hi guys another 2 questions

Firstly, I have worked out how to get each completed booking to the spreadsheet then Zapier takes over to create the report and send it each Monday morning. however when it does this or someone books or adds a booking it prints in to sheets every booking not just the last booking. Am i missing a step. Here is the link to my zap  https://zapier.com/shared/1aed64a01025c0c04dd77e82ef52c3beb54c122f

Below is how it is put into a spreadhseet

 

I also want my webhook to catch any time an appointment changes, in particular if this appointment change changes the last appointment date. How can I do this? My new Zapier webhook link keeps failing 

Basically when the last appointment date changes for any customer either when they initially book or update it i want it placed and updated for that customer in the spreadsheet in order to publish a quick report weekly to me

 

Userlevel 7
Badge +14

@MattATSoCalYouthSports

Is there a way of automatically update the airtable form either my booking software (Amelia)?

Here’s a help article about how to use Amelia with Webhooks as the Zap trigger: https://wpamelia.com/web-hooks-settings/

 

Create automation to send me a report when that persons last appointment falls within certain parameters?

Try creating Airtable View with Filters and use that View to trigger the Zap.