Forum Discussion

BrianBrian2's avatar
BrianBrian2
Qrew Member
10 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
    6 years ago
    Hi Joel,
    would you care sharing your code here?
    I'm attempting something similar with little/no experience in GScript.

    thanks