Auto-Insert Records to Excel with the Zapier API Connector

Send barcode scans to Excel Online

Automatically post barcode scans to pre-defined sheets through the API connector service provided by Zapier.

The Players

Microsoft’s Excel is a tool offered within the Office ecosystem that offers a spreadsheet application considered by millions of users as the industry standard for spreadsheets. Excel Online is their cloud based version, now competing with formidable Google Sheets application which has been cloud based for several years.

The codeREADr platform combines best in class, enterprise-grade iOS and Android OS apps to quickly and accurately scan barcodes, The apps are integrated with codeREADr’s cloud-based SaaS service for creating custom AIDC workflows and for managing users and databases.

Zapier is a tool used to connect web apps together without requiring a developer. Non-technical clients can easily create an integration between two apps. A ‘Zap’ includes a Trigger and one or more Actions.

The Result

All three players have Application Programming Interfaces (APIs). Zapier is used to connect the codeREADr API with the Excel Online API.

When a codeREADr app user scans a barcode, the resulting scan record is posted to a target sheet hosted on Excel Online. That scan record can include the barcode value, description, app username, timestamps, GPS locations, voice-to-text form data, the answers to menu options, photos, and many other variables.

Whenever a Trigger happens in codeREADr, Zapier will automatically perform the Actions to insert the record into Excel Online.

Getting Started

For Microsoft Online you will need a paid plan (one month $10.00 minimum) because only files on ‘One Drive for Business’ (available with Office 365 and Sharepoint server) are supported currently with Zapier.

You can use codeREADr’s Free Plan to test the core features. However, you will need at least the 1-Device Plan ($14.99) to use the API. You can upgrade and downgrade at any time so there’s no long-term commitment required.

Helpful Links