Relative Content

Tag Archive for google-sheetsgoogle-apps-scriptimportgoogle-drive-api

Can you pull information from local HTML files with Apps Script automatically to GSheets to work around limitations of =ImportHTML?

I’ve been trying to create a tracker for my team, which involves pulling data from a jira-like website. Unfortunately, unlike jira, there isn’t an easy add-on for pulling data directly to a google sheet. I’ve attempted to use =ImportHTML as a function, but have found that it does not work with sites with authentication requirements, even if you have the log in information.