# How to add Google Calendar events to a table with Automations

**URL:** <https://connect.superhuman.com/t/how-to-add-google-calendar-events-to-a-table-with-automations/19764>\
**Category:** Ask the Community\
**Created:** [November 25, 2020, 10:18am UTC](https://connect.superhuman.com/t/how-to-add-google-calendar-events-to-a-table-with-automations/19764 "2020-11-25T10:18:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Julian\_Englert](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/julian_englert/32/17433_2.png) [@Julian\_Englert](https://connect.superhuman.com/u/Julian_Englert)\
**Post date:** [November 25, 2020, 10:18am UTC](https://connect.superhuman.com/t/how-to-add-google-calendar-events-to-a-table-with-automations/19764/1 "2020-11-25T10:18:01Z")

</div>

Hi, I’m using Coda to plan tasks and manage roadmaps for our team.

I’m displaying a “master” _task list_ in a Gantt view.

I also sync a calendar using the Google Calendar pack into a _events_ table. This one I display in the calendar view.

I thought it would be nice to have the calendar events also displayed in the Gantt view and I want to add them from _events_ to _task list_ using automations.

However, using “When: row changed” and “Then: add or modify row”, a new event in Google Calendar is **added twice** to _task list_ .

Any idea on how to fix that?

 ![image](https://global.discourse-cdn.com/coda1/original/3X/5/3/53d1a86abdb1c9eb652fcbcffaf31b4f0f107845.png)

---

<div class="post-metadata">

**Author:** ![Ben\_Lee](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ben_lee/32/49867_2.png) [@Ben\_Lee](https://connect.superhuman.com/u/Ben_Lee)\
**Post date:** [November 30, 2020, 2:22pm UTC](https://connect.superhuman.com/t/how-to-add-google-calendar-events-to-a-table-with-automations/19764/2 "2020-11-30T14:22:42Z")

</div>

The filter field in the “Then” part of your automation is where you set what rows are to be modified instead of added.

The Id you show in “Column 1” in your table might be a good column to use for this filter. If the Id’s match, edit the row, if they don’t match, add a new row.

Also, if the “Events” table is a working table, this automation will fire every time there is a change anywhere in the table, which might be a lot. I have similar setup for my meeting notes but I use a button instead. I could set an automation to push this button every hour or once a day. The disable field for the button will keep it from getting pushed every time.

[https://coda.io/@ben-at-coda/meeting-notes-synced-with-google-calendar](https://coda.io/@ben-at-coda/meeting-notes-synced-with-google-calendar)

---

<div class="post-metadata">

**Author:** ![Julian\_Englert](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/julian_englert/32/17433_2.png) [@Julian\_Englert](https://connect.superhuman.com/u/Julian_Englert)\
**Post date:** [December 4, 2020, 6:29pm UTC](https://connect.superhuman.com/t/how-to-add-google-calendar-events-to-a-table-with-automations/19764/3 "2020-12-04T18:29:45Z")

</div>

Worked, thanks for your help!