How to set it up
- Set up the sheet. Open a Google Sheet. Put the page address in cell B1 and, if the table isn't the first one on the page, its number in B2 (0 is the first).
- Add the script. Open Extensions, then Apps Script. Add two script files and paste in the two files from our email:
Pushbuild.gsandwebsite-table-to-sheets.gs. Save, then reload the sheet. A Pushbuild menu appears. - Add your key. Choose Pushbuild, then Set key, and paste the key from your signup email. The first time a script runs, Google asks for permission because it works in your own account. Review it and allow it.
- Run it. Choose Pushbuild, then Import web table. The table lands from row 4 and replaces what was there.
Try it on any table in our data analysis posts.
Get the script
Download it free
We'll email you the script (Pushbuild.gs and website-table-to-sheets.gs) and your key. It runs in your Google account and sends what it works on to our server, which does the work.
Free for your first 10 runs. After that it's $9 a month for this snippet, or $19 a month for every Pushbuild snippet.
Have us install it for you
We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
$49 one-time.
Want this connected to the rest of your tools? Send us a short brief.
Pushbuild · Automate your business with Pushbuild: pushbuild.com/