Streamline Event Ticketing with Google Sheets, Docs & Barcodes

Connect to Google Sheets

1. Add a Google Sheets credential in the Latenode Credentials panel using OAuth authentication. 2. Add a Google Sheets node to your Latenode workflow and select the Google Sheets credential you just created.

Connect to Google Docs

1. Add a Google Docs credential in the Latenode Credentials panel using OAuth authentication. 2. Add a Google Docs node to your Latenode workflow and select the Google Docs credential you just created.

Set up Google Sheet for Event Details

1. In the Google Sheets node settings, create a new spreadsheet and add columns for event details (name, date, location, etc.) and ticket information (attendee name, ticket number, barcode).

Create Google Doc Ticket Template

1. In the Google Docs node settings, create a new document and design the ticket template, including placeholders for the event details and ticket information.

Generate Barcodes

1. Add a JavaScript node to your Latenode workflow. 2. In the JavaScript node settings, write a script to generate unique barcodes for each ticket and insert them into the Google Sheet and Google Doc.

// Example barcode generation script
const barcodeGenerator = require('barcode-generator');

exports.main = async (inputs) => {
  const { ticketNumber } = inputs;
  const barcode = barcodeGenerator.generate(ticketNumber);
  return { barcode };
};