'How to use importxml to a website that requires log in?
I already known how to use the importxml to import a certain text from a website to Google Sheets. However, this website experience.aiesec.org requires log in. I have the username and password of course. I also have already log in to this website in by browser. But when using importxml, it acknowledge me as haven't log in yet. I also used the syntax https://username:password@url but it does not work at all. Any suggestion pls? Or I should use another service instead of Google Sheets?
Solution 1:[1]
The importXML() function runs from Google's servers not from your browser, therefore, will only work with websites that are publicly available and do not require authentication.
There are 2 ways to automate the import of data from experience.aiesec.org using Google Sheets:
- IF experience.aiesec.org HAVE public API
you can code a custom, time-triggered or event-triggered function in Google Scripts that will authenticate using whatever aiesec.org's API is requiring, then fetch the data and write it into your Google spreadsheet. - IF experience.aiesec.org DOES NOT HAVE public API
you can use a Chrome Extension like Data Scraper to periodically scrape the site into a CSV file and then import the CSV into your Google spreadsheet.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |