I would like to hire someone to write a script in google’s g-suite to replicate the actions performed by a Zapier task (as described in this post: Update Fields with Integrated Scripting Approach). I have a very simple use case, an existing Zapier task, as well as a simple explanation of what needs to be done, as follows:

1. Every minute, run a script that looks for new records in Table 1


2. For each new record, identify existing record in Table 2 via linked field ID


3. Update record in Table 2 with field value from new record in Table 1


4. Update record in Table 1 with status

Reply with contact information and I’ll be in touch.