Skip to content

Instantly share code, notes, and snippets.

@larsschenk

larsschenk/Demo-ActiveBarcode-REST-API-Google-Sheets.gs

Last active January 21, 2020 03:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save larsschenk/5f722cf9733ce2e8669664e3604d55d6 to your computer and use it in GitHub Desktop.
Save larsschenk/5f722cf9733ce2e8669664e3604d55d6 to your computer and use it in GitHub Desktop.
Download ZIP
Google Sheets users can add dynamic barcodes via the ActiveBarcode REST API into tables.
Raw
Demo-ActiveBarcode-REST-API-Google-Sheets.gs
=image(CONCAT("https://api.activebarcode.net/v1/png?code=CODE128&access=YOUR-KEY-HERE&text=",ENCODEURL(A1)))
@larsschenk
Copy link
Author

larsschenk commented Jan 20, 2020 •
edited

Google Sheets

Google Sheets users can add dynamic barcodes via the ActiveBarcode REST API into tables.
It's pure and simple. No Add-On and no script is required with this straight forward approach. Just use the url from the REST API directly in the IMAGE function and that's it. If the content of cell A1 changes, the barcode changes automatically, too.

This screenshot shows the resulting barcode in the Google Sheet that encodes the content of cell A1.
Demo-ActiveBarcode-REST-API-Google-Sheets

https://www.activebarcode.com/rest/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment