In Progress

Automate report generation from API

I need to automate monthly report generation for individual clients by filling our pre constructed template (Excel) with data from API and generating a PDF report from that.

We also need to generate the graphs. These graphs aren't available through the API

so you'd have to recreate them based on the data that you pull from the API and we'd

like it to look as similar as the ones we share in our template.

At the click of a button, it should populate our tables.

We will be plugging into Ouraring API.

Example of report page: [login to view URL]

Arrows are pointing to what should be dynamic.

The pdf template will be shared with serious bidders.

Skills: Excel, Excel Macros, Excel VBA, Web API, Web Scraping

See more: wpf code report generation, google maps api path example, solidworks api programing example, kibana automated report, automatic pdf generator, elasticsearch report generator, document generation api, pdf generator api, kibana report examples, report generator api, kibana reporting tab missing, mysql, css, html, data processing, software architecture, excel, python, linux, web scraping

About the Employer:
( 3 reviews ) Parnell, Auckland, New Zealand

Project ID: #19020465

Awarded to:


Hi there, my name is Andres and I’m the excel expert of our team. I can do what are you requesting as is something I’ve been doing since 2012 as a data analyst and then as a freelancer. There would be no problem with t More

$400 NZD in 7 days
(85 Reviews)

23 freelancers are bidding on average $493 for this job


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( More

$470 NZD in 3 days
(666 Reviews)

HI, I am good at Excel VBA. I have referred the image that shows Sleep score and Average. I would like to discuss the graphs and pdf you are looking for. Also, share the link to extract the data to check the p More

$500 NZD in 2 days
(817 Reviews)

Dear Client, I am an experienced VBA and excel developer and have served the clients throughout the globe. Please have a look at my profile to get an insight into the quality of my services. I have reviewed your More

$500 NZD in 5 days
(135 Reviews)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

$500 NZD in 6 days
(302 Reviews)

Hello Sir Im excel VBA macro and formula Expert :) please give me link of API for get the data. and for Creating PDF report and Graph we can do it in excel part :) so the important things please give me your API lin More

$588 NZD in 10 days
(340 Reviews)

Greetings! I have reviewed the screen cast as well as took a brief look at the Oura API documentation. I can help with your requirement. Please share the Excel and PDF templates. Being a full time freelancer work More

$200 NZD in 4 days
(167 Reviews)

Hello, My name is Miguel Febres and you can locate my resume and certifications in the following links: [login to view URL] [login to view URL] In my 10+ years of e More

$500 NZD in 10 days
(42 Reviews)

Ok Sure

$500 NZD in 4 days
(95 Reviews)

Hi there, I am interested in your project. I would approach your project by using Python with Django. The data will be visualized on a website. Let check a sample system below: Price tracking system: http://etuannv.c More

$988 NZD in 10 days
(46 Reviews)

Hello, I can do this you want in excel using power query as i have advanced excel skills and over 8 years in the field. Please check my portfolio to see my work. Thanks!

$500 NZD in 5 days
(26 Reviews)

Hi, I am an expert in Excel, Access VBA, MySQL, Google Sheet, Google Data Studio and Power BI. I can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interactive Real Tim More

$300 NZD in 4 days
(62 Reviews)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$158 NZD in 2 days
(91 Reviews)

Hello How are you I have read your job description in detail . I am Xu It is a piece of cake Please contact me and Let's discuss more thanks for your posting . hope to hear from you .

$555 NZD in 10 days
(15 Reviews)

My company conducts annual member surveys for a large organization. Each member need to receive a report comparing it's performance against other members. Due to the number of reports need to be generated this has to b More

$500 NZD in 10 days
(2 Reviews)

Hi - I have done this kind of API querying and building reports several times and even have utilities that i would be able to reuse. Please initiate a chat so that we can discuss this and take it forward. Regard More

$470 NZD in 10 days
(24 Reviews)

Excel VBA automation consultant I am blessed to be able to do what I love, and I think my reviews shows in my work. I love problem solving, and creating automated solutions to streamline processes and save my clients More

$500 NZD in 10 days
(2 Reviews)

Hello i can help you to generate your reports from API with graphical presentations, I will make code in PHP which will consume your API data export that as excel and PDF and also interface where we will show live da More

$744 NZD in 15 days
(2 Reviews)

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. And i have checked the image in the link given. I understand the value of deadlin More

$250 NZD in 1 day
(9 Reviews)

Hi. i am a full web developer with over 5 years on ****In SPECIAL very familiar with webscrap, VBA, excel***** I have read your description and have interests in your project. I have rich experie More

$350 NZD in 10 days
(0 Reviews)

Hi i can make automation script to fetch data from api and insert into excel. i will create graph also. send me a message for discussion, thank you.

$800 NZD in 2 days
(0 Reviews)