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
10 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