Google Sheets Scripts
Budget: £10 – £50 GBP
I have a Zapier zap which adds a new row to a Google Sheets document when a new order is created in Shopify. The order corresponds to a teaching course which has a limited capacity. I need some scripts to be created so that when a new row is added to the sheet, it will check if the course name and date column values already exist in the sheet- if they exist then the capacity of the new booking should be added to the value in the the existing row, otherwise it should be added as a new row.
Additionally, when the course row capacity reaches a minimum number that I specify, I need an email to be sent through Gmail to a specified email address.
There may be additional requirements as the project develops but this is what is required to start with. Please let me know if this is achievable via scripts along with a price to complete it. Thanks.
Additionally, when the course row capacity reaches a minimum number that I specify, I need an email to be sent through Gmail to a specified email address.
There may be additional requirements as the project develops but this is what is required to start with. Please let me know if this is achievable via scripts along with a price to complete it. Thanks.