Forum Discussion

BrianBrian2's avatar
BrianBrian2
Qrew Member
11 years ago

Passing Data to Google Sheets Directly from a Report

Anyone have any experience using the ImportHTML() function in google sheets? I'm simply trying to import a summary table into a google sheet using the ImportHTML() google sheets function. The argum...
Data import and export
reports and charts
roles and permissions
ArchiveUser's avatar
ArchiveUser
Qrew Captain
9 years ago
If you are comfortable doing a bit of coding in Javascript you can use the Google Apps Script UrlFetchApp.fetch() method to connect to the Quickbooks API and get the data and then push it into a spreadsheet.  I don't have a ton of experience with this yet, but I have completed a basic proof of concept.
CarlosCarlos's avatar
CarlosCarlos
Qrew Assistant Captain
7 years ago
Hi Joel,
would you care sharing your code here?
I'm attempting something similar with little/no experience in GScript.

thanks