Connect to Google Sheets with Nexsets for Google Sheets

Important Nexla Help Center Update:

Nexla's Zendesk Help Center pages are being deprecated and will soon no longer be available.

Nexla Documentation is now the home for Nexla's User Guides, with improved formatting and categories that are easier to navigate, providing a better overall user experience.

Please update any bookmarks to the new Nexla Documentation site (docs.nexla.com/user-guides).

_______________________________________________

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.

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. 

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.

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

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.

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.

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.

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.

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.

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.