How to add a Google Sheets table widget
The Google Sheets Table widgets allow you to embed a full, scrollable spreadsheet into your dashboards, using data from any Google Sheet in your Google Drive account.
Show clients a spreadsheet highlighting content marketing work, recent sales leads, financial data, billable hours, or even analytics from any 3rd party marketing channel of your choice.
This article will walk you through the process of adding a custom Google Sheets table widget to a client marketing dashboard.
First, ensure that you've connected your Google Sheets/Google Drive account to the campaign by following the instructions in this article.
Once you've done so, add the widget itself by navigating to the campaign dashboard in which you'd like to add the widget. Click “Edit Dashboard” at the top right-hand corner.
The add widget menu will automatically appear on the right-hand side of your dashboard.
In the “Integrations” section, search (using the magnifying glass) or scroll down to Google Sheets and click through for more options.
From here select the “Table” widget. Then drag and drop your Google Sheets table into your dashboard.
Your widget will be added to your dashboard. Please click the “...” ellipsis at the top right-hand corner of the widget to edit and add more details of the Google Sheets table you would like to show.
What's Next:
So you've added a Google Sheets table widget. Great! Now, let's get it configured.
Need even more customization? Add a custom text box widget, with support for images and HTML formatting.
Not sure where to start with our widgetized marketing dashboards? Check out this quick tutorial.