<% user.full_name %>
<% util.level ? util.level.title : '' %>
Explorer Pioneer Apollo Viking Voyager Pathfinder Orion
Points
<% user.points ? user.points.toLocaleString() : 0 %>
Badges
<% util.badgeCount %>
Streaks
Congratulations You've <% util.newestBadge.isCurriculum ? 'completed' : 'earned' %> the
<% util.newestBadge.title %> <% util.newestBadge.isCurriculum ? 'curriculum' : 'badge' %>!
previous
next
Share to Social Media
Linked In Facebook
Status
<% util.level ? util.level.title : '' %>
<% util.level ? util.level.points : '' %>
<% util.nextLevel ? util.nextLevel.title : '' %>
<% util.nextLevel ? util.nextLevel.points : '' %>
Level up! <% util.levelPointsRemaining %> points to go
Level up! <% util.levelPointsRemaining %> points to go
Badges
Completed Hitchhikers Track Completed Knowledge Graph Track Completed Pages Track Completed Page Builder Track Completed Search Backend Track Completed Search Frontend Theme Track Completed Search UI React Track Completed Solution Templates and the Admin Console Track Completed Technical Skills Track Completed Platform Basics Track Completed Listings Track Completed Reviews Track Completed Industry Overview Track Completed Analytics Track Completed Industry Overview & Product Basics Track Completed Multi-Language Experiences Track Completed Chat Track
<% util.expandBadges ? 'Less' : 'More' %>
Playground Accounts
New +
No Playground Accounts
Create Playground +
View Profile
Log Out loading
Mission Complete! 🚀
Congratulations, you’ve completed your first module!

We hope you enjoy exploring the rest of the site. Please don’t forget to leave us feedback - we are constantly looking to improve. Happy Hitchhiking!
Home
Welcome to Hitchhikers! 👋
To learn more about the platform we encourage you to get started by completing the Hitchhikers Program Track and earning your first badge!
Start Here
Close notification
Guide
Connect Google Sheets to Yext
Arrow Back
Completed
Introduction
Introduction
completed
Completed 1
Step 1
Link Google Account to Yext
completed
Completed 2
Step 2
Install the Google Sheets App
completed
Completed 3
Step 3
Configuring the Connector
completed
home

Introduction | Yext Hitchhikers Platform

Google Sheets allows users to store data in the cloud using a spreadsheet format. Users can store entity data as rows or columns, and can now use the Google Sheets data connector to pull in all content from a Google Sheets spreadsheet into Yext. The Google Sheets data connector contains pre-configured setups that allow you to sync data to Yext and create individual entities based on the stored data.

Custom Functions Added

gs_replace_comma

  • Replaces all commas outside of a cell value with a vertical pipe (|) to ensure that the text string is delimited appropriately between each cell and preserves any commas embedded within a cell value.
book
Prerequisites

This guide assumes you have a basic knowledge of Google Sheets and Yext, and that you have:

  • A live Yext account.
  • A live Google account.
  • A Google Sheets spreadsheet. Note that if your file is in .xlsx or .csv format, you must download your file as a Google Sheet prior to using the Connector.
  • Entity Types in the Knowledge Graph that correspond to the data you will be retrieving from Google Sheets. These can be either built-in or custom entity types. See the Manage Entity Types unit for more on enabling built-in entity types, and the Create Custom Entity Types unit to learn how to add custom entity types.
<% elem.innerText %>