Skip to main content

Nexsets for Google Sheets

Available now in the Google Workplace Marketplace, Nexla's Google Sheets Connector brings any of your datasets created in Nexla right into Google Sheets where you need it.

  1. To get started, first you need access to Nexla, and Nexsets created in your account. Head to Nexla.com and click "Get Demo" to get started with Nexla, and to learn more about Nexsets click here.

  2. Once you're set up on Nexla, head to the Google Workplace Marketplace, either from a browser or in Google Sheets itself under Add-Ons > Get Add-Ons and then searching for "Nexla". Select Nexsets Connector and click Install.

  3. Now that the add-on is installed, you have to link and authenticate your Nexla account.

Authenticating in the Add-On Pane​

Navigate to the Add-Ons tab in the toolbar. You should now see Nexsets Connector listed. Hover over Nexsets Connector and click Configure. Choose Production, click Get Access Token, and then a popup window should appear. Type in your username and password or use Google Single Sign-On. Your unique access token should appear. Click to copy and paste it into the Access Token box and click Authenticate.

mceclip0.png

Getting Your Data​

After configuring your account, you can now click List Nexsets to view your available Nexsets, or type in the ID right away if you already know it.

mceclip1.png

Clicking List Nexsets, or navigating to Add-Ons > Nexsets Connector > List Nexsets will show all available datasets in your account. Select the one you created and click Connect to Nexset.

mceclip2.png

Fill in any required parameters, then click Fetch Data. Your data will then automatically import into your sheet.

mceclip3.png

Nexsets Connector Functions​

Besides the commands in Nexsets Connector under Add-Ons, you can also simply type commands into any open cell in your sheet with commands. All commands start with "NEX_" as you can see below.

mceclip5.png

NEX_GETDATA​

Select any cell in your sheet and type in "=NEX_GETDATA(DATASET ID, [OPTIONAL PARAMETERS]". Pass just the dataset ID in the first field, followed by a comma and any optional parameters. Your dataset IDs should be listed using NEX_LISTNEXSETS or the List Nexsets command in the Add-Ons menu and any necessary parameters can be shown using NEX_GETPARAMETERS. Press Enter and your dataset will fill into the spreadsheet. Run the command again to fetch the most recent available data.

mceclip8.png

mceclip7.png

NEX_LISTNEXSETS​

Select any cell in your sheet and type in "=NEX_LISTNEXSETS". Press Enter. All Nexsets available in your account should appear with their ID number and name.

mceclip6.png

NEX_GETPARAMETERS​

Select any cell in your sheet and type in "=NEX_GETPARAMETERS(XXXXXX)" with the dataset ID. Press Enter. Any parameters available for that dataset to be passed when calling your Nexset will appear.

mceclip9.png

NEX_AUTHENTICATE (Advanced)​

If you're given an API Url and Token, use this command to configure your account. Select any cell in your sheet and type in "=NEX_AUTHENTICATE(API_URL, TOKEN, SYNC_SERVER)". Press Enter and your account should configure automatically.

mceclip10.png

Conclusion​

Using these commands in Nexsets Connector for Google Sheets, data from anywhere can easily be connected through Nexla and integrated into Google Sheets in minutes. Remember to run NEX_GETDATA or click Nexsets Connector > Get Data frequently to ensure you're working with the most recent version of your data. To learn more or request a demo, head to www.nexla.com and click Get Demo.

Interested in seeing a demo of this feature? Check out a [step-by-step tutorial and demo video on our blog here] (https://www.nexla.com/nexla-google-sheets/).