Kapalı

Google Sheets Automation

Authentication:

Store at user level - once a user is signed in, doesn’t need to sign in again.

Authenticate using our server’s backend authentication mechanism

Authentication credentials to be hosted in sidebar

Data sources and APIs

Each workbook should be created from a template. It will have

Cover page

One or more presentation tabs

Control sheet with details of APIs to be called and reference of source table destinations

One or more Data tables tabs

data table APIs to be called initially to populate metadata

A set of data table APIs to be called subsequently with dynamic queries (read from cells)

Data Update

Auto refresh of APIs at hourly or longer intervals (user option)

Refresh of APIs through user action (refresh button)

Handle pagination

Auto Archiving

Reports to be auto archived at end of the day

A folder structure to be created under root folder SilaeData for Year/Quarter/Month/Week

Archived reports to refresh only on user action and not automatically

Beceriler: Google Apps Scripts, Google Sheets

Müşteri Hakkında:
( 0 değerlendirme ) Dubai, United Arab Emirates

Proje NO: #34796032

Bu iş için 5 freelancer ortalamada $19/saat teklif veriyor

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am a Daha Fazla

$20 USD / saat tutarından itibaren
(6 Değerlendirme)
5.2
akritisood94

Hello, I have carefully read the given details, understood your requirements and I believe that I can deliver very fast. Send me a message to finalize and start right away. Thanks!

$20 USD / saat tutarından itibaren
(10 Değerlendirme)
4.5
aruls1962

I’m a professional Engineer who has spent the past 7 years building, developing, and perfecting systems (from the ground up) through Google Sheets. With over 30 years of experience in the industry, I’ve not only learne Daha Fazla

$23 USD / saat tutarından itibaren
(19 Değerlendirme)
4.2
Xinxilig

Hi, I 've recently worked on a similar project for a bank institution that wanted its data to be connected from Sheet to Data Studio through Bigquery using apps script. (See my reviews on Freelancer). I've read the spe Daha Fazla

$18 USD / saat tutarından itibaren
(4 Değerlendirme)
2.7
caabdul

Hi, I am good in google sheets and apps script. However I still have to try my first project for APIs. Let me handle this project for you, if I succeed only then you pay $150, else pay nothing. Regards, Abdul

$15 USD / saat tutarından itibaren
(5 Değerlendirme)
3.5