Find Jobs
Hire Freelancers

Google Sheets functions that allow users to call an API and return a desired key value

£10-20 GBP

In Progress
Posted about 4 years ago

£10-20 GBP

Paid on delivery
I would like someone to create a couple Google Sheets functions that can be used using Google Sheets syntax (eg. =getemployeedata(A2, EmailAddress) ) that can call an API and parse the result. For instance if I called a function called getemployeedata, I could provide the contents of cell A2 (eg. an employee id) and parse the response for the key called EmailAddress and expect to get back user@[login to view URL] I will supply the APIs, I just need the generic function call.
Project ID: 23714555

About the project

6 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

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:
User Avatar
Hello Sir / Ma'am, I have gone through your requirements, and it describes a pretty standard use case of google app script, developing custom formulas for your google sheet. I would be making use of UrlFetchApp class provided in Google App Script in order to make the API calls and return the desired value in the cell after parsing the API call response. With my 3+ years of experience in developing on Google App Script, I assure of a quality tool following the standard industry practices ensuring robustness and modularity. Looking forward to work with you. Warm Regards, Murtaza Sadriwala
£15 GBP in 1 day
5.0 (1 review)
2.3
2.3
6 freelancers are bidding on average £16 GBP for this job
User Avatar
I'm a Google Sheets expert, with a comprehensive knowledge of the google apps script language. Google Sheets runs on Javascript, and the apps language is very similar. I have a lot of knowledge with JS, and work frequently with API's for my full time employment, so this sounds like a great fit for my skillset. I am available right now to help you with your project, please contact me to discuss the details.
£15 GBP in 1 day
5.0 (7 reviews)
3.9
3.9
User Avatar
I understand the task and I have such experiense (GS, fetching data, parsing) as well. I hope the mentioned API is clear and not complicated. Otherwise I have to estimate delivered days more carefully. Thank you.
£15 GBP in 3 days
5.0 (2 reviews)
2.0
2.0
User Avatar
Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Server, MySQL, SQLite, PostgreSQL, Firebird Write Automation apps including: * Automation Desktop apps. Some examples: Automation Playing Games, Automation Start/Stop/Click 3rd party apps * Automation Web apps. Some examples: Automation Web Scraping apps, Automation Web Crawling apps * Automation Data Processing apps: Automation formatting data to a specified template * Automation Data, Document Converting apps * Automation Macro, VBA for all apps in MS Office (Excel, Word, Outlook), OpenOffice, GoogleSheet * Automation Installers/Setups * Convert your Manual tasks to Automation solutions Write Web Service, Web API, Desktop API apps. Some examples: Google API, Bing API, Facebook API, MS API Fix/Solve any errors in your OS, apps
£10 GBP in 1 day
5.0 (1 review)
1.7
1.7
User Avatar
Hi, I can easily do it. I have experience with javascript and REST APIs. Regards Krisztian
£20 GBP in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
London, United Kingdom
4.9
6
Payment method verified
Member since Nov 29, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.