Using Timed Reports With Google Sheets
Want to automatically send your boberdoo system reports to Google Sheets? Alongside options like Amazon S3, FTP, and Email, you can now seamlessly connect your boberdoo timed reports to your Google Workspace.
Watch the video walkthrough below or follow our step-by-step guide to configure the integration.
Step-by-Step Setup Guide
To get started, you will need to have both your boberdoo system and your Google Workspace account open.
Phase 1: Create a Google Project & Enable the API
Create a New Project: Go to the Google Developer Console for Workspace (developers.google.com) and make sure you are logged into your company's Google account. Click to Create a Project.
Name Your Project: Give your project a recognizable name (e.g., Company Leads or Lead Portal). This represents the organization the files will be submitted to within Google Drive. Click Create.
Copy the Project ID: Once created, navigate to your Project Info. Copy the Project ID (which usually matches the name you just created) and paste it into the Project ID field in your boberdoo Timed Reports setup.
Enable Google Sheets API: In your Google project, look for the prompt to enable APIs. Go to the API Library, search for Google Sheets, click on it, and click Enable.
Phase 2: Configure Credentials & OAuth
Configure OAuth Consent Screen: Go to the OAuth consent screen tab.
Select Internal (since this is for internal company use and you are not authorizing external users). Click Create.
Name the app (keeping it the same as your Project ID is easiest).
Enter your support/help desk email address in the required user support and developer contact fields. Click Save and Continue (you can skip the other optional steps).
Create Credentials: Navigate to the Credentials tab at the top and click Create Credentials.
Select OAuth client ID.
For Application Type, select Web application.
Add Redirect URI: Under Authorized redirect URIs, click Add URI.
Go back to your boberdoo system—you will see a specific redirect URL provided in the setup options.
Copy that URL from boberdoo and paste it into the Google setup. Click Create.
Copy Client ID & Secret: Google will now generate a Client ID and a Client Secret. Copy both of these strings and paste them into their respective fields back in your boberdoo system.
Phase 3: Configure Your boberdoo Timed Report
Now that the systems are connected, you can finish setting up the actual report in boberdoo (Reports > Timed Reports > Add New):
Select Report Data: Choose the specific report you want to send and the date period (e.g., the last 30 days).
Choose File Handling: Decide how you want the data to apply to your Google Drive files:
Save data to separate files (creates a new file every time).
Add new data to existing file (strips the header and only appends new data—great for ongoing reports).
Overwrite existing data with new file.
Name the File & Schedule: Enter the file name you want to appear in your Google Drive (e.g., My_Leads.csv). Select the days and times you want the report to run automatically (e.g., every Friday at 9:00 AM). Make sure the report is set to Active.
Save: Click Save.
Phase 4: Authorize and Test
Authorize Google Sheets: After saving, you will see a small exclamation mark icon next to your new timed report. Click it to authorize Google Sheets.
Sign In: This will trigger the OAuth consent screen you built earlier. Click Yes to authorize, sign in with your Google Workspace account, and click Allow to grant access.
Test Your Report: To ensure it is working, click Send report now. You should see a success message. Check your Google Drive, and you will see the newly generated CSV file instantly uploaded with your report data!
If you have any questions or need help guiding you through this setup, please reach out to our support team and we would be happy to help!