Trying to Automate Linked Google Calendar to Display Appt. Details

Topic Labels: Automations
557 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hey All,

I created a base to keep track of my doctor's appointments (I've recently been trying to see a lot of specialists in a short time while aiming to keep track of pertinent details regarding my visits).

I've successfully linked my appointments to Google Calendar, but what I'd like to do (if possible) is on the day before each scheduled doctor's appointment {Email Send Date}, have Airtable update my linked Google Calendar Event with select information (from my Airtable table's fields), specifically my doctor's address, my concerns, notes, and the doctor's phone #. 

As you'll see in the automation I attempted, my idea was when the record matches the conditions (when "E-mail Send Date" is Today)I wanted to see if I could have Airtable update a Google Calendar Event. ("E-mail Send Date" is a field I've made with a formula listing the date the day before the appointment

I'm not sure if that's the way to accomplish what I'm trying to do, but the Event ID and everything else confused me. I've added an Event ID column in this table, but I really don't know that it's doing what I think it's supposed to do. 

Then, you'll see that I got the error message, "Google reported an do not have permission to it."

Can anyone help me clarify how to do what I'm trying to do? 





I tried to create an automation through which I could 

0 Replies 0