LoadLane changelog

Version 1.0 — 12 November 2026 · first release

• First version: a Google Sheets™ add-on that imports CSV, TSV, JSON or the answer of an API from a web address into a tab of your spreadsheet. Open it from Extensions → LoadLane → Open LoadLane.
• Sources: any https:// address. GET with query parameters and request headers, such as Authorization: Bearer … or X-API-Key; POST with a JSON body (Pro).
• Keys stay with you: header values and parameters marked secret are kept in your own Google account, never in the spreadsheet, and shown masked. Other editors see the names only and type their own values. Your values are sent only to the site they were saved for: if the address moves to another site, they are not sent until you save the source again.
• Formats: CSV (comma or semicolon), TSV and JSON, detected by themselves or chosen. For JSON, choose the list with a path such as data.items, or click one of the lists LoadLane found. Nested objects become columns such as customer.name; lists of values are joined.
• Preview of the first 20 rows, with nothing written. Choose, rename and reorder the columns. Keep values as text keeps leading zeros.
• Where it goes: any tab, or a new one, from the start cell you choose. Replace (free) clears exactly the block LoadLane wrote last time. Append (Pro) adds rows under the ones already there and can skip rows whose ID is already in the sheet. Snapshot (Pro) adds every import under the last one with an Imported at time.
• Pages (Pro): a next-page link or cursor in the JSON, a page number or offset parameter, or the Link header. Up to 50 pages. A next page on another site is refused.
• Schedules (Pro): every hour, every 2, 3, 4, 6, 8 or 12 hours, every day or every week on the days you tick, at the hour you choose, in your time zone. One hourly check in your account runs what is due, also while the spreadsheet is closed.
• Results you can see: every source shows its last result, such as Wrote 1,240 rows from 5 pages to Orders!A1., and its last error: the HTTP code and the first 200 characters of the site’s answer, with your keys removed. A busy site (429 or 5xx) is asked twice more. An optional LoadLane log tab (Pro).
• Limits: 10 MB per request, 50,000 cells per run of one source, 200 columns. Free: 3 sources per spreadsheet. Pro: 25.
• Permissions: spreadsheets, script.external_request, script.scriptapp, script.container.ui and userinfo.email. No Drive or Gmail permission; none restricted. See Permissions.