🖇️Connecting Retable Data using Dokin

This step-by-step guide will walk you through the process of connecting Retable to Google Sheets, Slides or Docs using the Dokin add-on.

Dokin is a powerful Google Workspace add-on that allows you to connect various data sources and integrate them seamlessly into your spreadsheets, documents or presentation. With Dokin, you can sync Retable data to:

• Manage and analyze your Retable data in a Google Sheets spreadsheet,

• Create dynamic presentations in Google Slides with data from Retable,

• Create dynamic documents in Google Docs with data from Retable.

Preliminary : how to install and open Dokin add-on ?

Install Dokin add-on

If you haven't already, you need to install the Dokin add-on for Google Workspace. To do this, follow these steps. You can refer to this tutorial to know how to install Dokin.

Open Dokin add-on

After successfully installing Dokin:

• For Google Sheets: create a new Spreadsheet or open an existing Spreadsheet.

• For Google Slides: create a new Presentation or open an existing Presentation.

• For Google Docs: create a new Document or open an existing Document.

Then, click on “Extensions”, “Dokin” and then “Start”.

Step 1: Select the Retable App

On the home page, you'll find a list of your imported data, as well as a button for creating new connections. Click on the "Connect New Data" button.

Next, a dropdown menu will appear. Here, simply pick the "Retable" app from the list of options.

Click on "Connect new Data" and select the Retable App

Importing data from Scratch or from a Template

When it comes to importing data, you have two options: starting from scratch or using a template you've created before. Templates can significantly speed up the data import process. To discover how to create and reuse templates, please consult our step-by-step article.

Step 2: Connect to your Retable Account

If this is your first time using Dokin or if your previous connection has expired or been revoked, you need to enter your Retable API Key.

You can find the API Key on Retable website, following this url.

Enter your API Key from Retable to connect your account

Step 3: Select the Data to Import from Retable

Follow these steps to choose the data you want to import from Retable. This process allows you to import all rows from a specific Retable table, that meet your specified criteria.

1. Select a Table

Begin by selecting the Workspace, Project and Retable from which you intend to import data.

Select a Retable

2. Select the Fields

Next, pick the fields you wish to display in your import. You have the flexibility to select anywhere from one to an unlimited number of fields, tailoring the import to your precise needs.

Once you've made your selections, you can rearrange the fields to your liking. This can be achieved with a simple drag-and-drop action, ensuring that the data is presented in the most logical and useful order for your specific needs.

Select the Fields you want to display in your Import

3. Optional: Customize your Import

3.1 - Assign a Name to your Import

Choose a meaningful name for your import process. This name will help you easily identify and manage your imported data within Dokin.

Enter a Name for your Import

3.2 - Set Up Scheduled Refresh

This option will automatically refresh your data at specific intervals. You can choose the frequency, including the day and time, and configure notifications to receive alerts when data is refreshed.

Google Sheets

An automatic refresh means that at your specified intervals, the information imported into your Google Sheets will be automatically updated. This ensures that your data remains accurate and reflects the latest changes.

Google Slides and Google Docs

An automatic refresh means that at your specified intervals, the information inserted into your Google Slides or Google Docs will be refreshed. This dynamic updating ensures that your presentations and documents always reflect the most current data, saving you the hassle of manual updates.

Frequency

Specify how often you want Dokin to automatically refresh your imported data. This ensures that your data remains current without requiring manual updates.

The frequencies are available:

• No Refresh (default)

• Weekly: Data refreshes every week. Select a specific day of the week and time for data refresh.

• Daily: Data refreshes every day. Choose the time for daily data updates.

• Hourly: Data refreshes every hour.

• 15 mins: Data refreshes every 15 minutes.

Notifications

You can opt to receive notifications each time your data is refreshed. The available notification options include:

• None: No notifications will be sent.

• Slack: You will receive a Slack message whenever your data is refreshed. If it's your first time selecting this option, you'll be prompted to connect to your Slack workspace.

• Email: You will receive an email notification each time your data is refreshed.

You can define an auto refresh for your data, with notifications

3.3 - Additional Customization [GOOGLE SHEETS ONLY]

Remove Dokin Header

By checking this box, you can hide the header banner displaying the app name and connection information on your sheet. Instead, the fields will be inserted directly on the first line of your sheet, providing a cleaner and more customized presentation of your data.

Below is an overview of the data with header.

Below is an overview of the data without header.

🎉 Congratulations, your Retable data are connected. Now, what's next ?

Google Sheets

When clicking on Connect, Dokin will create a spreadsheet importing all the information you've requested.

Once data is imported, you can edit it and send data back to Retable. You can find step-by-step instructions on how to do this in our detailed article.

Google Slides

When clicking on Connect, Dokin will display a new Connection on the home page.

From there, you can choose to insert each cell data as dynamic content or you can create multiple presentations using mail merge.

Google Docs

When clicking on Connect, Dokin will display a new Connection on the home page.

From there, you can choose to insert each cell data as dynamic content or you can create multiple presentations using mail merge.