Labs
Google Sheets Inbound Integration
this feature is currently in alpha be one of the first customers to try it! please share any feedback with the charthop team how to setup a alpha feature contact charthop support or your csm if you have one they can activate the feature for you read below for setup instructions and context on how the feature will work overview bring business and other company data into charthop with our google sheets integration contact the charthop team to learn more places to utilize data from google sheets tables home page profile tabs dashboards forms (text blocks) resource pages letter templates setup instructions installing the application in labs, enable "google sheets integration" you will then see "google sheets" display on the apps page under the tab "other available apps" once you click install, it will guide you to connect your google account so we can access the data in the shared sheets once installed, you can rename the application to better match the data you are pulling in charthop cannot access data that you have not explicitly mapped to charthop tables or fields sync frequency you can choose to automate this sync and have it run daily, or you can manually run it at your discretion mapping to a table in charthop note the table needs to be created first in charthop before you can map to it all values must match exactly, including any trailing white spaces if there is a space, dash, or non alphabet character in the name, wrap the name in \[""] you can wrap any value in the brackets and quotes to map to a column in a table, you need to know the table code name (see below), and the field code name for the column you can map columns from different sheets within the same google sheet you need to know the name of the sheet, and the name of the column in this example, the sheet is labeled customers and the columns we want to map are customer and contract end inbound field mapping example charthop table google sheet column customers customername (this column is marked as unique in the table) \["customers"] \["customer"] customers contractend \["customers"] \["contract end"] the first field mapped needs to be the unique field this is a value that does not repeat in its column, and can be as simple as row number notice above how the values are wrapped in brackets and quotes contract end must be wrapped in those values to be read by charthop however, you can wrap any other values for consistency once all of your field mappers are set, you can click "save mappers" and run the sync google sheets integration access initially, only owners have the ability to install and edit the google sheets app fields synced from google sheets utilize charthop's fields docid\ xyrlltzxie bv4zkzes g , so anyone in the organization can be given access to view the data in the corresponding fields