How to Generate Barcode and Save to Dropbox with Using Zapier

This demo teaches the step-by-step process of generating barcode and saving it to Dropbox using an integration of and Zapier applications.

Useful Resources:

Step 1: Create a New Zap and Trigger

To begin, let’s create a new zap and have Google Sheet as input. We’ll have New Spreadsheet Row as the trigger.

Select Google Sheets and New Spreadsheets Row As The Trigger

The input spreadsheet looks similar to this. Specify the trigger to every new row added to the worksheet. The end goal is to have a QR code generated for every new row by utilizing the Invoice No field.

Spreadsheet Record Of Invoice To Generate Barcode

Step 2: Set Google Sheet Account Connection to Zapier

Once App & Event are specified, you need to set the Google sheets account.

Choose Google Account

After Zapier connects to Google Sheets account, provide the source Spreadsheet and Worksheet.

Select Source Spreadsheet

Step 3: Implement Test Trigger

With all event configuration setup for Google sheets, it’s time to do a Test Trigger. Before hitting the Test Trigger button, add a new invoice row in the Google spreadsheet.

Test Trigger

Step 4: Start the Barcode Generation Process

We have completed the first step of specifying the input and the event apps. Now it’s time to set the next event, which should generate the barcode.

Spreadsheet Row Found

Step 5: Select as the App then the Barcode Generator Function

In this step, we aim to generate a barcode based on Invoice No. To begin with, select as input application.

Choose App & Event For

Next, specify the Barcode Generator as the event. As the name suggests, this event generates almost all types of barcodes.

Select Barcode Generator

Step 6: Configure the Account

Select Account

Step 7: Specify the Barcode Generation Related Fields

  • In the Barcode Value field, select InvoiceId.
  • In Barcode Type To Generate field, select QR code.
Customize Barcode Generator With Spreadsheet And Barcode Data

Step 8: Test & Review

Send Barcode Generator Data To Test And Review

The result returns the Barcode URL along with other fields such as status, remaining credits, etc.

Test Was Processed Successfully

Here’s the QR code generated in

Image Of QR Code Output

Step 9: Store Barcode Value in Dropbox

In the new app, select Dropbox as the app and choose Upload File as the event.

Upload File In Dropbox

Step 10: Select your Dropbox Account then Configure Upload Fields

Select Dropbox Account

Let’s configure the Dropbox upload fields.

  • In the Folder field, select the Dropbox folder where the new files will be stored.
  • In the File field, paste the Barcode URL from
  • In the Overwrite field, select Yes or No.
  • In the Specify File Name field, select the Invoice ID.
  • And finally, in the Specify File Extension field, enter the file extension.
Customize File With And Dropbox Data

Step 11: Test & Review the Output

With all these configurations set, it’s time to Test & Review the output.

Send To Test And Review

Here is the empty Dropbox folder before testing.

Empty Dropbox Folder To Store The Barcode

When we click the Test & Review button, it will upload the file to Dropbox.

Test was succesful

Step 12: See Result

If we look at the Dropbox folder again, we should see the new Barcode file added.

Barcode Successfully Added Inside Dropbox

In summary, the image below shows all the applications needed to produce the result.

Overview From Spreadsheet, Barcode Generation, and Dropbox Storage

In this tutorial, you’ve checked the step-by-step process of generating barcode and saving it to Dropbox using and Zapier integration.

Video Guide