Brightspot CMS User Guide

Importing tags or sections from a Google Sheet


You can import tags or sections into Brightspot from a Google Sheet.

Note
In order to import Google Drive files into Brightspot, you must first have configured the integration. For details, see Configuring the Google Drive integration.

To import tags or sections from a Google Sheet:

  1. In the header, click the search field to open the search panel.
  2. Under Global Filters, in the Any Content Type filter, select Google Drive File.
    Any Content Type search filter.png
  3. Click the title of the Google Sheet you want to import into Brightspot.
  4. Under the Converter list, select Google Sheet.
    Note
    Using this menu, you can also import the Google Drive file as a general digital asset. For details, see Importing Google Drive files as DAM assets.
    Google Drive import widget.png
  5. Under Convert to Type, select either Section or Tag.
  6. Toggle on Has Header Row if your Google Sheet includes a header row. When toggled on, Brightspot lists the headings for you as you configure field mappings. When toggled off, Brightspot lists the columns as letters.
  7. Under Field Mappings, click add_circle_outline, then do the following:
    1. Under Column, select the column containing the field you are mapping.
    2. Under Field, select one of the following:
      • Display Name—Sets the values in this column as the names of the tags or sections in Brightspot.
      • Description—Sets the values in this column as the descriptions of the tags or sections in Brightspot.
      • Parent—Sets the values in this column as the parents of the tags or sections you are importing into Brightspot. If no parent by the given name already exists, Brightspot creates it and assigns the tag or section to which it pertains.
    3. Repeat steps 7a–7b for all columns in the Google Sheet.
  8. Click Import.
  9. When the import completes, refresh the page to view the list of the tags or sections you imported.
    Note
    All tags or sections imported from a Google Sheet to Brightspot are published upon the completion of the import, but without URLs. For details on the options you have available when updating them, see Tag and Section.

Example Import

The following image displays a Google Sheet that has been configured for import into Brightspot.

Sample spreadsheet for import.png

In the Import widget, under Field Mappings, three mappings are configured pertaining to the three columns in the sample spreadsheet:

  • Mapping 1Brightspot maps column A as parent.
    Field mapping 1.png
    • In the Column field, column A (referred to in the Google Sheet header as "Parent") is selected.
    • In the Field field, Parent is selected.
  • Mapping 2Brightspot maps column B as tag name.
    Field mapping 2.png
    • In the Column field, column B (referred to in the Google Sheet header as "Display Name") is selected.
    • In the Field field, Display Name is selected.
  • Mapping 3Brightspot maps column C as description.
    Field mapping 3.png
    • In the Column field, column C (referred to in the Google Sheet header as "Description") is selected.
    • In the Field field, Description is selected.

After clicking Import, Brightspot performs the import according to following mappings:

  • Apple is created as a tag with Red as its parent and A red fruit as its description.
  • Kumquat is created as a tag with Orange as its parent and An orange fruit as its description.
  • Lemon is created as a tag with Yellow as its parent and A yellow fruit as its description.
Imported tags or sections.png
A list of tags imported from the Google Sheet.
Imported tag.png
The tag Lemon imported from the Google Sheet. The parent Yellow and the description A yellow fruit are associated to it.
Previous Topic
Importing articles, blog posts, and documents from a Google Doc
Next Topic
Importing Google Drive files as DAM assets
Was this topic helpful?
Thanks for your feedback.
The elements that get you up and running in a matter of days, from pre-built content types, to modules, to landing pages.

Content types
Modules
Landing pages
Everything you need to manage and administer content within Brightspot CMS, including plug-and-play integrations.

Dashboards
Publishing
Workflows
Admin configurations
A guide for installing, supporting and administering code on the Brightspot platform, including integrations requiring developer support to use.

Field types
Content modeling
Rich-text elements
Images