Suljettu

Automate Google Sheets using Scripts

Looking for someone who could integrate and automate process between Google sheets and drive folders, create customized workflows that could automatically initiate at a specific time, that is triggered by time. Mostly you'll have to use scripts.

So, there are 2 tasks we want to achieve.

First is... We want some kind of automation which can remove duplicates, But that's not just after comparing 1 column. Multiple columns should be compared and then if things match up the oldest row should be retained and other(s) should be deleted. Along with each row, there's a folder(at a path defined by two columns of each row) in our Google drive containing relevant documents and images which too must be deleted at the same time... So if a row is deleted from the sheet(manually or by automation or by any 3rd party app), its relevant folder must also be deleted automatically.

Second.. We want to put a workflow in place which shall schedule custom SMS(recommend us a good and affordable SMS service for SMS within India) for each new row which is being added. The data is not directly entered into the sheets. A form is linked to the sheet which inserts the data entered into the forms onto the sheet.

Also.. I would like to add that the SMS is supposed to be 2 way. If the recipient of the message doesn't respond I should get a list of such recipients on daily basis. And if they respond. Let's say "Y" there will be a column of the sheet updated and if they respond "N" once again that particular data along with the relevant folder should be deleted

Further, whenever the date is updated that is after receiving SMS response or manual update once again an SMS is to be scheduled for the 7th day with similar response actions

You may also check out this video where I have explained my requirements.

[url removed, login to view]

I was confused while making the video... it's column E, F, H & I which should match up.

Sorry for the inconvenience

Only offer if you think you can do the above?

Taidot: Excel, Excel Macros, Excel VBA, Visual Basic

Näytä lisää: google sheets scripts, looking for a developer working with google sheets, i am looking for someone to write a google apps script in google sheets, google apps script for beginners, google apps script web app, record macro google sheets, google apps script examples, google apps script tutorial pdf, google spreadsheet script get cell value, google sheets script functions, google sheets script examples, add marker existing google map using javascript, automate google maps using, fetch kmz file google earth using javascript, animation google map using database, google checkout using api sample projects, automatizar automate google analytics, build real estate websites google maps using php, integrate google maps using mysql, custom google street view scripts

Tietoa työnantajasta:
( 0 arvostelua ) India

Projektin tunnus: #15713433

5 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

rajafaizan

Hi, I'm Dynamic Professional has good command on Office tools like (Excel, Word, PowerPoint, VBA and Macro). I will done it as per your requirement. Let's chat for further process. Thank You Relevant Skills and Exp Lisää

₹7777 INR 3 päivässä
(30 arvostelua)
4.5
₹7777 INR 3 päivässä
(11 arvostelua)
4.0
Manjeet70

Hi, Yes I can.

₹7777 INR 3 päivässä
(0 arvostelua)
0.0
softtronicstech

I would be able to do this. below are some demos I made using google sheets [login to view URL] demo using an external api in sheets [login to view URL] related demo, where i created a dasboar Lisää

₹6666 INR 10 päivässä
(0 arvostelua)
0.0
₹5555 INR 3 päivässä
(0 arvostelua)
0.0