Google Sheets Automation


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

Taidot: Google Apps Scripts, Google Sheets

Tietoa asiakkaasta:
( 0 arvostelua ) Dubai, United Arab Emirates

Projektin tunnus: #34796032

5 freelanceria on tarjonnut keskimäärin $19/tunti tähän työhön


Top 1% in 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 Lisää

$20 USD / tunti
(6 arvostelua)

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 / tunti
(10 arvostelua)

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 Lisää

$23 USD / tunti
(19 arvostelua)

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 Lisää

$18 USD / tunti
(4 arvostelua)

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 / tunti
(5 arvostelua)