Google Apps Script - Update Sheet with File Data

$10-30 USD

Completed

Posted

about 1 year ago

$10-30 USD

Paid on delivery

I need a Google Apps script that does the following: 1. Every time a file is added to a specific folder I want the file info to be logged into Google Sheets 2. When updating the Google Sheet, the file name of the added file needs to be parsed and updated to the spreadsheet as follows ===FILE NAME=== 2023-03-08_162435_out - Marie ((747) 555-1234 Mobile).mp3 2023-03-08_162950_inc - Big Desi (+1 816-555-2345 Mobile).mp3 2023-03-08_164244_out - Marie ((747) 555-1234 Mobile).mp3 2023-03-08_163657_out - Desiree Stalls ((314) 555-3456 Mobile).mp3 ===SHEET DATA=== (commas represent separate cells) DATE,IN OUT,DATA,DURATION,NOTES 2023-03-08 16:24:35,out,Marie ((747) 555-1234 Mobile) 2023-03-08 16:29:50,inc,Big Desi (+1 816-555-2345 Mobile) 2023-03-08 16:42:44,out,Marie ((747) 555-1234 Mobile) 2023-03-08 16:36:57,out,Desiree Stalls ((314) 555-3456 Mobile) 3. The script should auto run every 30 minutes or so and update the spreadsheet with any new files added to the folder.

Google Apps Scripts

Google Sheets

Google Spreadsheets

Project ID: 36157087

About the project

5 proposals

Remote project

Active 1 yr ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@vishal54sharma

Lets do this. Ping me in chat so that we may discuss the details Broadly what i can understand is that you want to have the file name and other info in the gsheet via appscript Lets sort this out quickly Thanks Vishal

$30 USD in 2 days

5.0

(70 reviews)

5.0

5 freelancers are bidding on average $40 USD for this job

@subinpvasu

Hi, I'm a Google Apps Script developer. I can do this file data transfer to google sheet if you are adding the file to Google Drive. If you are adding the file to any other folder, like server locations, I can do it with google sheets api using PHP. Come, Let's have a chat and see further

$50 USD in 1 day

5.0

(4 reviews)

3.5

@hashirqureshi01

I have extensive experience in developing Google Apps Scripts and have worked on similar projects in the past. I have a deep understanding of Google Sheets and can create custom scripts to automate your workflow. I am available to start working on this project immediately and I am confident that I can deliver a high-quality solution within the agreed timeline. Please feel free to contact me if you have any questions or if you would like to discuss this project further. Thank you for considering my proposal. I look forward to hearing from you. Cheers

$60 USD in 3 days