TL;DR:

1. To begin, let’s create a new zap and have Google Sheet as input.
2. The input spreadsheet looks similar to this.
3. Once App & Event are specified, you need to set the Google sheets account.
4. After Zapier connects to Google Sheets account, provide the source Spreadsheet and Worksheet.
5. With all event configuration setup for Google sheets, it’s time to do a Test Trigger.
6. We have completed the first step of specifying the input and the event apps.
7. In this second step, we aim to generate a barcode based on Invoice No.
8. Specify the Barcode Generator as the event.
9. Configure the PDF.co account.
10. Specify the Barcode generation related fields.
11. Now, it’s time to do a Test & Review.
12. The PDF.co result returns the Barcode URL along with other fields such as status, remaining PDF.co credits, etc.
13. Here’s the QR code generated in PDF.co.
14. Now, let’s store this Barcode value into Dropbox.
15. Select your Dropbox account.
16. Let’s configure the Dropbox upload fields.
17. With all these configurations set, it’s time to Test & Review the output.
18. Here is the empty Dropbox folder before testing.
19. When we click the Test & Review button, it will upload the file to Dropbox.
20. If we look at the Dropbox folder again, we should see the new Barcode file added.
21. In summary, the image below shows all the applications needed to produce the result.

Useful resources:

Step by step guide:

1. 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

2. 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.

Sample Invoice File

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

Choose Google Account

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

Customize Spreadsheet Row

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

Test Trigger

6. 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

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

Choose App & Event PDF.co

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

Select Barcode Generator

9. Configure the PDF.co account.

PDF.co account

10. Specify the Barcode generation related fields.

  • In the Barcode Value field, select InvoiceId.
  • In Barcode Type To Generate field, select QR code.

Barcode Type to Generate

11. Now, it’s time to do a Test & Review.

Test and Review

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

Test Successful

13. Here’s the QR code generated in PDF.co.

QR code result

14. Now, let’s store this Barcode value into Dropbox. In the new app, select Dropbox as the app and choose Upload File as the event.

Upload File in Dropbox

15. Select your Dropbox account.

Dropbox Account

16. Let’s configure the Dropbox upload fields.

  • In the Folder field, select the Dropbox folder where the new files will be stored.
  • In the Filefield, paste the Barcode URL from PDF.co.
  • 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

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

Test and Review

18. Here is the empty Dropbox folder before testing.

Dropbox folder

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

Test was succesful

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

Barcode inside Dropbox

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

Overview of configuration

Related Pages: