At this stage, you can configure Advanced options, if needed. If you want to connect multiple tabs to Preset, make sure to name each sheet differently, and add each sheet as a new table, using its unique URL. īefore continuing, make sure that the Google sheet has its permission set for anyone with a link. You can view the sample Netflix GSheet here. In the Type of Google Sheets Allowed field, retain the default selection of Publicly shared sheets only.įor this walkthrough, we are going to use a Google Sheet that contains data about Netflix titles. In this example, we simply used the default Google Sheets. In the Display Name field, enter a meaningful name for the new connection to your public Google Sheet. In the Toolbar, hover your cursor over the plus + icon, then Data, and then select Connect Google Sheet. To learn how to connect Preset to a privately-shared restricted Google Sheet, please see Google Sheets (Private) Connection. This is a Google Sheet that has the permission setting of Anyone with the link.
Let's start by learning how to include data from a publicly-shared Google Sheet in Preset. In order to connect a Google Sheet, you will need Administrator permissions on your workspace. Preset supports both of these data sources, as described below. Two of the most popular sources of data to include in a database are Google Sheets and CSV files. Check with your Team Admin for additional access. 👤 This documentation is intended for Workspace Admins and Primary Contributors (on CSV upload functionality).
0 kommentar(er)
