![]() We request the minimum read/write scopes necessary to make the Airtable Sync integration work. The sync operation will retrieve all events in the calendar within the date range, and automatically create a calendar view to display the events. ![]() Once you’ve selected your desired settings, click the “Create table” button. By default, deleted events will be removed. Whether or not deleted events in the selected calendar should be removed from the Airtable table.Right now, the options are manual syncing and automatic syncing which happens around every 5 minutes. Try CData Connect Cloud and get real-time data access to 100+ SaaS, Big Data, and NoSQL sources directly from your cloud applications.Before creating your synced table, there are Settings options that allow you to choose how often you want to sync, and how to handle records deleted or hidden in the source (in this case, Google Calendar). You can add more data to your workbook for calculations, aggregations, collaboration, and more. New, you have a direct, cloud-to-cloud connection to live Airtable data from your Google Sheets workbook. Live Access to Airtable Data from Cloud Applications Optionally add Filters, Sorting, and a Limit.In the CData Connect Cloud panel in Google Sheets, click Import.In the Add-On panel, click Authorize to authenticate with your CData Connect Cloud instance.Back in Google Sheets, click Add-ons and open the CData Connect Cloud Add-On.Search for CData Connect Cloud Add-On and install the Add-on.Click Add-ons and click Get Add-ons (if you have already installed the Add-on, jump to step 5).Log into Google Sheets, create a new sheet (or open an existing one).The steps below outline connecting to CData Connect Cloud from Google Sheets to access live Airtable data. With the connection configured, you are ready to connect to Airtable data from Google Sheets.Īccess Live Airtable Data in Google Sheets Navigate to the Permissions tab in the Add Airtable Connection page and update the User-based permissions.These are the same names of the views as found in the UI. ViewNames : A comma separated list of views in the format of (table.view) names.These are the same names of tables as found in the UI. ![]() TableNames : A comma separated list of table names for the selected base. ![]() In the introduction section you can find "The ID of this base is appxxN2ftedc0nEG7." Click on Airtable API, or navigate to and select a base. To obtain this value, it is in the same section as the APIKey. To obtain this value, after logging in go to Account. ViewNames is an optional parameter where views of the tables may be specified.
0 Comments
Leave a Reply. |