Google Apps Script - Update Sheet with File Data

$10-30 USD

Terminado

Publicado

hace alrededor de 1 año

$10-30 USD

Pagado a la entrega

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

ID del proyecto: 36157087

Información sobre el proyecto

5 propuestas

Proyecto remoto

Activo hace 1 año

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@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 en 2 días

5,0

(70 comentarios)

5,0

5 freelancers están ofertando un promedio de $40 USD por este trabajo

@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 en 1 día

5,0

(4 comentarios)

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 en 3 días