Hello, how are you?
Hope all are weel.
After reading the documents attached to job, these would be my approach to the task.
See the required authentication keys to the API endpoint.
If it is user based, those could be asked and then stored in the script instance for further use.
Else just make the API connection with general keys;
The values in the response could be displayes in the addon, in a HTML template, or just be inserted in the sheet, or even both.
For formating cells, we could pass the values thru the HTML template and run the formating functions in the background;
For exporting data there are several ways, like sending an email document, sending a html formated template in email, or making it avaiable with an API endpoit, when it recives a GET request it respond with a formated JSON with the information needed.
That would be my approach,
Hope here from you,
Best Regards,
Felipe