Database Wizard for Google Sheets

This section describes how to connect Google Sheets tables using the Desktop Designer Step-by-Step Database Wizard.

1. In the Data menu, click All Databases to open Step-by-Step Database Wizard, then click Next.

   

2. Database Type Selection window opens. Select Google Sheets, then click Next.

   

3. Connection Settings window opens. Click Sign in.

   

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

   

   Click your account to log in.

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

   

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

7. In the Connection Settings window select your Google Spreadsheet, then click Next.

   

   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.

8. Your spreadsheet fields are now connected to your solution. You can remove the fields you don't need. Then click Finish.

   

9. Finish your database wizard with the remaining wizard steps:

   • Label Copies per Record

   • Create Objects

   • Date Preview and Other Table Settings

Your Google sheet is now connected to your label/solution.