Question 1

How to fix Google Drive refused to connect

Accepted Answer

It may happen that you open an add-on in Google Sheets and immediately crashes with a message saying drive.google.com Refused to Connect. This is a known issue in Google Sheets and it likely happens when a user is logged into multiple Google accounts in the same Google Sheet.

Fix - Google Drive Refused Connection

If your default Google account is not the one that is associated with the Google add-on, the sidebar of the Google add-on may display a grey screen with the message drive.google.com refused to connect.

On your computer, open the Google Chrome browser.

At the top right, click the 3-dot vertical menu and then choose New Incognito Window.
A new window appears.
Now open the same Google Sheet and sign in with your default Google account.

Logout of Multiple Google Accounts

Alternatively, you may visit accounts.google.com/logout to immediately sign-out of multiple Google accounts. The error is displayed due to permission conflict between Google user accounts inside Google Sheets and Google Forms.

If you are still facing any issue with Google Drive refusing to connect, please contact support.

Question 2

Using formulas in spreadsheets

Accepted Answer

Conduit offers two ways to transfer data to spreadsheets:

Building block “Save dataset to Google Sheets”

Formulas
In this article, I will talk about using formulas.

Conduit supports two formulas to be used in Google Sheets.

REPORT - Place a table to a spreadsheet
METRIC - Place a single metric to a spreadsheet

REPORT

The Report formula copies a table from Conduit into a spreadsheet. It has four parameters:

report
start_date
days
row_count

report- data source name

The name of a data source is the first parameter of the formula. The source of data can be any building block in the workflow. The screenshot below shows 4 data sources:

table1 - Raw data from Facebook
report8 - Data from Facebook aggregated by Ad Account
csv3 - Raw data from a spreadsheet
union4 - The result of merging rows from table1 and rows from csv3

The formula can use any data source from any workflow.

Date range

The Report formula always retrieves data for a range of dates. This range can be selected in two ways:

Explicitly in the formula, e.g. =report(“table1”, "2022-05-01", 7)
Implicitly: the time range selected in the workflow is used

We recommend using explicit date ranges. To select dates, you can use cell references, e.g. =report(“table1”,B1,C1)

More information you can find here.

Question 3

How to send a report to a private channel in Slack

Accepted Answer

Please (1) open the channel's properties and the Integrations tab.

(2) Click Add an App button (3) Find the "Conduit.app" Click Add

Question 4

Okta integration

Accepted Answer

Welcome to the Conduit Integration Guide for Okta. This guide will walk you through the process of setting up and using the Conduit app with Okta. With Conduit, you can simplify your data operations and visualization, while leveraging the power of Okta's Single Sign-On (SSO) capabilities.

Step 1: Sign up for Conduit

Before you can integrate Conduit with Okta, you'll need to sign up for a Conduit account. Visit https://getconduit.app and click on "Sign Up" to create a new account.

Step 2: Connect Conduit with Okta

Log in to your Conduit account and navigate to the "Connections" tab.
Find "Okta" in the list of available integrations and click the "Connect" button next to it.
You will be redirected to Okta's OAuth page. Log in to your Okta account if prompted and click "Allow" to grant Conduit access to your Okta data.

Step 3: Configure the Integration

Once connected, you'll be redirected back to Conduit. In the "Connections" tab, click on "Configure" next to Okta.
Choose which data types (users, groups, etc.) you want to synchronize between Conduit and Okta.
Optionally, set up any additional data filters or transformations as needed.

Step 4: Import Data from Okta

Navigate to the "Imports" tab in Conduit.
Click on "Add Import" and choose "Okta" as the source.
Configure the import settings, such as frequency, date range, and data types.
Click "Save" to start the import process. Conduit will now fetc

Question 5

Wrike Integration

Accepted Answer

In this article, we're going to learn how to connect Wrike with Conduit, the ultimate data connector and automation platform for seamless integration. By linking these powerful tools together, you can unlock a new level of efficiency and productivity in managing your projects and data. Let's dive in and explore the simple steps to establish a seamless connection between Wrike and Conduit

Connecting Wrike with Conduit

Log into your Conduit account.
Navigate to the Connections tab.
Look for Wrike in the list of available integrations.
Click on the "Connect" button next to Wrike.
Follow the on-screen instructions to authorize Conduit to access your Wrike account.

By following these steps, you can easily connect Conduit with Wrike and start integrating your selected data between the two platforms. This integration enables you to streamline your workflow, collaborate more efficiently, and enhance productivity by combining the capabilities of Conduit and Wrike.

Setting up Imports from Wrike

To configure data imports from Wrike in Conduit, please follow these steps:

Navigate to the "Imports" tab in the main menu of Conduit.
Click on the "Create Import" button and select Wrike from the available options.
Configure the specific import settings, such as selecting the Wrike account or data types you wish to import.
Customize any mapping or transformation rules to ensure the imported data is structured according to your requirements.
Save the

Question 6

Zoho integration

Accepted Answer

The integration between Conduit and Zoho allows you to seamlessly export deals, contacts, and leads from your Zoho account into Conduit's data platform

Connecting with Zoho account

To connect Conduit with Zoho, follow these simple steps:

Log into your Conduit account.
Navigate to the Connections tab.
Find Zoho in the list of available integrations.
Click on the "Connect" button next to Zoho.
Follow the on-screen instructions to complete the authorization process and establish a secure connection between Conduit and your Zoho account, and then select the data to download

Setting up an import from Zoho

To set up data import from Zoho in Conduit, follow these steps:

Navigate to the "Imports" tab in the main menu.
Locate and click on the "Create Import button and select Zoho in the list
Configure the specific import settings, such as selecting the Zoho account or data types you want to import.
Customize any mapping or transformation rules to ensure the imported data is structured according to your needs.
Save the import configuration, and Conduit will start importing data from your Zoho account based on the defined settings into a Google Spreadsheet

By setting up the import from Zoho in Conduit, you can automate the retrieval of data from your Zoho account and leverage Conduit's data manipulation and visualization features to gain insights and ma

Frequently Read Articles

Browse All Categories