Google Sheets Scripts

£10-50 GBP

已完成

已发布

将近 2 年前

£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.

Google Sheets

Zapier

项目 ID: 33762524

关于此项目

11提案

远程项目

活跃2 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@vishal54sharma

Hey, I can assist you in creating an script which will scan for the new order and if the date and order matches or already exist then it will do the function as per your described criteria. Note: There is no way to trigger or to detect a new row being added with third party application . This can be done by running the script every minute or every 5 minute to check for new row addition and do the processing. Lets connect in chat to discuss further.

£20 GBP 在1天之内

5.0

(33条评论)

4.4

11威客以平均价£51 GBP来参与此工作竞价

@gangabass

I can provide you a Google Sheets script that will check each new row added to the sheet and perform actions according to your rules. All I need to start is your sheet sample for testing. Roman

£50 GBP 在1天之内

5.0

(5条评论)

3.9

@IgeS

Hi there, It's better to leave the zap function as is and create a separate solution that will address the above requirements instead. I would to suggest to query the sheet in a new sheet that has time-triggeres script that sends email if a course reaches a minimum number required. Please message me if this is something you consider. I'll be standing by to help. -Ige

£50 GBP 在1天之内

5.0

(8条评论)

3.5

@Xinxilig

Hi, I just finish a task for a client that wanted her client google form responses to trigger events in her google calendar using Apps script. (See my last Job on Freelancer). So I think I can help on your project too. Hope for a good future collaboration... Best Regards...

£40 GBP 在5天之内

4.4

(1条评论)

1.1

@agishlisho

Hi, Good day! I have 3 years of experience in Backend. : Appscript, Java, Node js Frontend. : React, JSP, Html Data base : Mongo db , MySQL Additional : AWS I understand your requirement, You need additional automation when u receive response from zapier, which we can do with appscript. Come in chat to discuss further..

£30 GBP 在2天之内