Search gmail for new emails with label, search term, and from address. if any fields are blank, leave off searching for that field.
Populate spreadsheet columns with email date, name, from email, subject, and text body of email.
1 new row per new email found.
Asana workspace, custom term
Asana project, custom term
Find Asana task, search for it
Search inside workspace, and project for task with "from email address" from google spreadsheet row.
use [login to view URL] to do the following.
Update task found from searching of task.
Task completed? No
Create a Subtask: under parent task found
Notes: Body of email from google spreadsheet column
Due on: 2 days from date on google spreadsheet
Assignee: Custom field
Follower 1: Custom field
Follower 2: Custom field
Follower 3: Custom field
Tag: Custom Field
Can't find parent task? Create a new task inside Asana project: custom term.