Sitebulb integrates with the Google Sheets API, so you can push Sitebulb-generated-spreadsheets directly into Google Sheets. If you aren't aware of the benefits of using Google Sheets as part of your audit workflow, check out our separate guide on this topic.
Adding your Google account
Before you can get going with Google Sheets, you will need to authenticate a Google account to use.
As soon as you press 'Export to Google Sheets' within an audit you will see a call to action to connect your Google account.
You are able associate multiple different Google accounts, in case you use different accounts for different clients.
You can upload pretty much any export you find in Sitebulb, directly into Sheets. Once you hit an Export button, you'll be able to select the Sheets option:
The first time you do this, you'll need to authorise a Google account to use, but you won't need to keep doing this step in the future:
This step is super straightforward, a browser window will open up and you just need to select or sign in with the right account...
...and then verify that you are happy for Sitebulb to access your account:
Once this has been added, you'll see a basic confirmation screen, and can then just return to the tool.
Exporting to Sheets
Then, select the Google account from the dropdown, and you need to give the Sheet a name (or use the pre-filled option) and hit Export and Upload.
The upload will typically take a few seconds to process, however if you are uploading spreadsheets with LOTS of data, this can take a few minutes (see further below on Data Limits).
Once the upload is complete you will be presented with two options, either to go into the 'root' Google Drive folder, or directly into the uploaded Sheet itself.
If you select View Google Sheet this will dive you straight into the uploaded spreadsheet, which will show the URL data as it appears in URL Lists in the tool:
Sitebulb Google Drive Folder
If you instead select Google Drive Folder you'll see how the export has gone in, and that Sitebulb has created a 'Sitebulb Exports' folder in Drive, which will be the place that all future Sitebulb data is saved to. Within this you can also see that the data is organised further into Projects and Audits, so your data stays within a consistent structure in the future.
Within Drive, you can of course then click through into the Sheet itself.
Note that you can also jump directly into the Sitebulb Google Drive folder from anywhere within the audit, by pressing the Google Drive button in the top navigation.
Different Types of Export
Sitebulb is designed to offer you all the exports you commonly need, ready and prepared for you as soon as the audit is finished - most of these are CSV files but occasionally we use formatted Excel files for more custom requirements. Additionally, we also provide complete flexibility within the URL Lists or the URL Explorer to build your own filtered lists and export these as well.
(Almost) every single export can be pushed into Sheets. If the option is available to use Sheets, you'll see it as a dropdown option when you click the Export button.
The different types of export include:
- Grouped Hint exports (e.g. 'On Page Hints')
- Individual Hint exports (e.g. 'Meta description is missing')
- Exports from URL Lists
- Specific pre-built exports (e.g. 'Broken Links')
- Bulk Exports (e.g. 'Audit Summary')
It doesn't really matter what the different types are, however the important thing to note is that '#1 Grouped Hint exports' are displayed a little differently in Drive.
Grouped Hints will be displayed inside a 'Hints' folder, whereas anything else you do (including a single Hint export) will just appear as a file underneath.
Grouped Hint Exports
By 'Grouped Hints', what we mean is a complete set of triggered Hints for an entire report section in Sitebulb (e.g. 'On Page'). Sitebulb will produce a linked summary sheet, with all the individual Hints accessible via worksheets at the bottom.
To generate these, you need to go to a section, for example 'On Page', then click the export button alongside 'Printable PDF'. From the dropdown, select the 'Export all Hints...' option.
In this example below I did this for On Page. As you can see there is a 'front page' summary sheet, which is linked through to individual Hints worksheets via the links on the left and the tabs at the bottom.
Clicking through to an individual Hint worksheet will show the URL data itself, as it appears in URL Lists in the tool:
Google Sheets is not designed with scale in mind. On bigger sites, Sitebulb CSV exports can go into millions of rows, but Sheets is not able to handle this quantity of data. You'll find yourself frustrated with the results if you try to push everything you possibly can into Sheets, for every audit, regardless of website size.
The limits you need to bear in mind are:
- Sheets has a hard maximum of 5 million cells.
- The minimum number of columns they allow in a Sheet is 26.
- This results in a hard maximum limit of 192,000 rows.
- File size limit is 100Mb.
- Sitebulb will truncate the spreadsheet (by rows) if you go over these limits.
Be particularly careful with Links exports, as it can be easy to underestimate their size. By way of example, this is an ecommerce site with only 22,000 internal URLs, somehow has 5,800,000 internal links (hello, mega menu):
Trying to upload this much data to a Google Sheet is a frightening prospect indeed, and if you try it you will be politely rebuffed:
Removing Google Account permission
If, for whatever reason, you decide that you no longer need/want Sitebulb to have access to Google Sheets, you can simply disable access through Sitebulb's global settings menu.
From anywhere within Sitebulb, click the Settings button:
Navigate to the Google Accounts tab and then select the Google account you wish to remove.
Note that there are separate permissions for Google Sheets and Google Analytics/Search Console. You can remove one permission and leave the other intact, just be sure to select the right one when you come to do this.