Google Sheets Script to Automate Gmail Search and Import CSV

$30-250 AUD

Opravljeno

Objavljeno

pred skoraj 6 leti

$30-250 AUD

Plačilo ob dostavi

Hi everybody, This is task for someone with google app script knowledge + advanced google sheets knowledge I am trying to create a Stock Portfolio Spreadsheet that can automatically search my Gmail inbox for (specifically titled emails, that have specifically titled) CSV attachments, and then import them onto a secondary Sheet of the aforementioned Stock Portfolio Spreadsheet. The script should adhere to a time-driven (clock) trigger and run once daily, and should be able to run as a background task (not requiring the Spreadsheet to be manually opened in order for the script to run) I will also require some instructional comments either in the script itself or separately that inform me of the modifiers for the; Sheet name, email title and file attachment title, so that I could edit them to my preference. Once the CSV file has been successfully downloaded and imported into my existing Spreadsheet, an IMPORTRANGE or similar function will be required for the existing spreadsheet to copy the new data across from the imported CSV file. This process will then repeat itself every weekday, possibly overwriting the previously imported CSV file

Excel Macros

Excel VBA

Google App Engine

ID projekta: 17258790

Več o projektu

4 ponudb

Projekt na daljavo

Aktivno pred 6 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

Dodeljeno:

@SBITServices

Hello gridskipper, I have read your project description and previously i have written many scripts for search emails periodically.I have 5 years experience in google sheets script programming. I can complete this task within time with 100% accuracy.I am very responsible towards our clients. I know my client needs and importance. Skills : Excel, Macros,VBA,Web scraping,Web Search, Data entry, Copy typing, Transcription works,Wordpress,Megneto,Woocommerce,Shopify,Prestashop etc With Regards, Bhaskar.

$100 AUD v 3 dneh

4,0

(11 ocen)

3,4

4 freelancerjev je oddalo ponudbo s povprečno vrednostjo $176 AUD za to delo

@schoudhary1553

Hi there..... Warm Greetings We came along with your request for Google Sheets Script to Automate Gmail Search and Import CSV and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Excel Macros, Excel VBA, Google App Engine We have worked on 350+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !

$250 AUD v 3 dneh

4,9

(14 ocen)

4,9

@archanaoswal

I have excellent command on Google Sheets and know how to read emails from gmail account using Google Sheets. I have done very similar projects before. For instance - Extract all mails and attachments from GMAIL to google sheet and drive respectively - Get emails from a particular sender and convert the csv file in it to Google Sheets - Get live cyptocurrency data and create dashboard using coinmarket API - Upload and Manage Videos in Vimeo using JSON API in google sheets - Twitter functionality like retweet, auto-tweet, and so on - Integrated Google Sheets, Forms and docs to create a dashboard and tracking system to track health data of individuals for a health care organization You can see the reviews of the same in my profile

$200 AUD v 3 dneh