Best answer

Adding and updating google tasks in airtable

  • 23 January 2021
  • 2 replies
  • 59 views

I am using the:

 

“Find or create record in Airtable when new task in Google Tasks “

 

It works, tasks are added. Yay!

 

I want to use:

 

“Update record in Airtable when new completed task in Google Tasks “

 

This does not work.  It will only let you link to a specific record which is fine the first time the task is completed.  But subsequently added tasks do not have the same record id and so the tasks are never marked as complete.

 

Anybody else tried this?  Or mad it work?

icon

Best answer by Troy Tessalone 23 January 2021, 20:36

View original

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

2 replies

Userlevel 7
Badge +14

Hi @ijducan 

Are you storing the GTask ID in the Airtable to find/reference later?

 

Zaps

Steps

  1. Trigger: GTasks - New Task
  2. Action: Airtable - Add Record (make sure to store the GTask ID)

 

Steps

  1. Trigger: GTasks - New Completed Task (use the returned “original id”)
  2. Action: Airtable - Find Record (by GTask ID)
  3. Action: Airtable - Update Record (using the Airtable Record ID from step 2)

Ah so i need a paid account to make it work then.

 

Thanks probly not gonna work.  Eveyone in the organization would need a paid account for this to work then.  mgmt is not gonna go for that.