Google Sheets

Section header image mobile

Coefficient allows you to import existing sheets from your Google Drive. You can choose between a specific tab from your Sheet and filter the data before import. 🙌🏻

Connecting to Google Drive

Import from My Drive

Schedule your Import, Snapshots, and Add Automations

FAQs for Google Sheets

Connecting to Google Drive

Before completing your first import, you will need to connect/authorize Coefficient to your Google Drive.

1. Open the Coefficient Sidebar and select "Import from".

Screenshot 2023-11-22 at 7.15.34 AM.png

2. Select "Google Sheets" from the options.

afrawrF.png

3. Click the "Authorize" button.

AFSAWF.png

 

4. You will be redirected to a new page, select the account you want to connect from.

DBSFV.png

5. Click the "Allow" button to give Coefficient access to your data.

GERG.png

6. From here, you can select the Sheet(s) you would like to import.  DVSDVG.png

Import from My Drive

1. Open the Coefficient Sidebar and click on the "Import from" button.

Screenshot 2023-11-22 at 7.15.34 AM.png

2. Select "Google Sheets" from the list.

afrawrF.png

3. A new pop-up window will show that allows you to select your file from the ‘My Drive’ tab.

ℹ️ NOTE: You can also import files that are shared with you from the ‘Shared Drives’ or ‘Shared with me’ tab on the window selection. GBDF.png

4. Customize your import by selecting a Tab and Range of cells. Make sure to specify if you want to designate a Header or “None”.

GFBFRB.png

5. Further customization can be done to this import by rearranging the column order, adding filters, or sorting the data before import. Note: If no import name is entered, your tab name will be Copy of + (name of worksheet)

DFGDG.png

6. Check the “Preserve formatting” box to apply the same style and format from your source sheet to this new import. (This can be cell highlights, text coloring, borders, etc)

Screen_Shot_2022-10-26_at_5.53.02_PM.png

 

7. Congratulations on your first import from another Google Sheets file! 🎉BDFTB.png

ℹ️ NOTE:  Conditional formatting will apply when the “Preserve formatting” option is enabled. (Data Validation, Cell Notes, and Comments are not supported by this feature.)

Schedule your Import, Snapshots, and Add Automations

Once you have pulled your data into Sheets using Coefficient, you can set up the following:

1. Schedule your ImportScheduled_Refreshes.png

2. Turn on SnapshotsSnapshot.png

3. Set Up Automations

AutomationswithGPT.png

FAQs for Google Sheets

If my original sheet has formulas on some columns, will it be copied over?

Coefficient will import the values and not the formulas from your source sheet. As a workaround, you can use the IMPORTRANGE() function.

I am having trouble importing from Google Drive. What steps can I take to resolve this?

There are a few things you can try:

  1. Confirm that you have “Editor” permissions for the sheet (Important with Shared Sheets). If you do not have “Editor” access, request this from the owner of the Sheet. Then try importing again.
  2. Confirm that the Sheet you are trying to import does not have any custom restrictions/protected ranges/Sheets. (Protected Ranges will block scheduled import refreshes)
  3. Verify if the owner of the sheet has an active Google account. (Google Rules and Permissions apply)

Was this article helpful? 0 out of 0 found this helpful