Connect to Google Sheets

You can use Google Sheets as a dynamic data source for label objects or form objects. Before you manually set up a database connection, open Dynamic Data Manager. This dialog enables the label designer to manage the variable data sources for label and form objects.

1. Click the Database Connections button in the Dynamic Data Manager ribbon and select Google Sheets as your database type.

   

2. New Database Connection Properties window opens. Click Sign in.

   

3. Your web browser opens with Sign in with Google options.

   

   Click your account to log in.

4. A new window with options to access your Google Account opens. Select both options:

   • See information about your Google Drive files.

   • See all your Google Sheets spreadsheets.

   Then click Continue.

   

5. Confirmation messages about successful connections appear in your browser and Desktop Designer. Close the confirmation window in Desktop Designer.

6. Select your Google Spreadsheet, then click OK.

   

   In the Spreadsheet list, you can also see sheets that are shared with your account. You can use the shared sheets the same way as your own.

   Important

   If you share your label with other clients, enable sharing of your Google Sheets so other clients can log in with their credentials.

   Loftware will prompt other clients for Google login when opening labels/solutions.

   Test Connection button starts a connection testing procedure. It shows if a connection with the selected Google spreadsheet has been established successfully. A confirmation or error message appears depending on the connection status.

7. Your Google spreadsheet is now connected. Add the table(s) you would like to use to the Selected tables.

   

8. Columns from your selected table(s) appear in the list of your Dynamic Data Sources. Click OK.

   

You can now connect data from your Google Sheets to your label objects.