Introducing Google Connector with Google Sheets Sync

We're thrilled to announce the release of an exciting new feature for RFIDLinked: the Google Connector with Google Sheets sync. This powerful addition streamlines data management by enabling seamless syncing of RFIDLinked files and RFID tag data with Google Sheets spreadsheets.

Explore Your Data Your Way

With RFIDLinked's Google Connector, you're not just syncing data—you're gaining control over how you view and organize it. When your data flows into the spreadsheet, it includes essential fields such as Tag Identified (TID), EPC (in hex format), Tag encoding type, GS1 Company Identifier, GS1 Product Identifier, and Serial Number.

RFIDLinked will sync all relevant tag data fields with Google Sheets.

But you also have the flexibility to rearrange, add, or remove columns according to your needs.  Don't need a particular column? Simply delete it. Want to incorporate additional asset management data alongside your tags? Go ahead and add a column wherever it makes sense for you. With this level of flexibility, RFIDLinked's Google Connector empowers you to tailor your data presentation precisely to your preferences and requirements.

Example of syncing google sheet with modified columns

Customize your sheet by rearranging, adding, or removing columns as needed.

RFIDLinked is smart enough to continue syncing the correct fields even with your changes!

Simplify Integrations with Third-Party Systems

While RFIDLinked has a full-featured API for more complex situations, our Google Connector can simplify integrations with third-party systems that already connect with Google Sheets. With just a few clicks you can quickly keep your tag data synced with a Google Sheet, opening the door to quickly share data with any existing third-party systems that have Google Sheet integrations without the need for any extensive development work.

How to get Started

Read our full instructions on our Knowledge Base: Google Connector Knowledge Base Articles.

Getting started is easy.

Log in to your RFIDLinked account at https://app.rfidlinked.com/ and navigate to the Connectors section in the left-hand navigation menu.

Create Connector

From the Connector list, click +Create and choose "Google" from the drop down menu.

Link your Google Account

Click on "Create Connector" 

You will be redirected to link a Google Account with RFIDLinked.  Select which Google Account you would like to use and Grant limited access to RFIDLinked to your Google Drive.

Setting a File to Sync with Google Sheets

Select a File for Syncing

For any File you wish to sync to Google Sheets, click the “Sync with Google Sheets” link.

Enable Syncing

Click the “Start Syncing This File” button and a new Google Sheet will be created in your linked Google Drive account, and all tags from your File will be synced with it momentarily.

Important Notes

  • When you create a Google Connector it will give RFIDLinked limited access to your Google Drive, only allowing it to access Files and Documents it creates itself.

  • Sync Frequency: Files set up to sync with Google Sheets will push changes into the Google Sheet approximately every 10 minutes, ensuring timely updates.

  • One-Way Sync: The sync process is one-way, with changes being pushed from RFIDLinked into the Google Sheet. Changes made directly in the Google Sheet will not be reflected in RFIDLinked.

With the introduction of Google Connector with Google Sheets sync, RFIDLinked empowers users with enhanced data management capabilities, simplifying workflows and driving efficiency. Get started today and experience the power of seamless integration firsthand!

Stay tuned for more updates and enhancements as we continue to evolve RFIDLinked to meet your needs.

Stephen Wise

Software Engineer, Technology & RFID Evangelist.

Previous
Previous

Case Study: Apparel and Outdoor Products Company