Google Sheets

Google Sheets is a spreadsheet program included as part of a free, web-based software office suite offered by Google within its Google Drive service. It has become the defacto spreadsheet program for many small businesses and has reduced the dependency on excel while adding collaboration into the mix.

Connecting to Google Account

You can import data from your Google Sheets into Mammoth. Follow these steps to fetch data from Google Sheets:

1. Navigate to APIs & Databases inside the Add Data menu.

1. Select Google Sheets from the list.

   

   Fig. 39 Selecting Google Sheets from the list of APIs and Databases.

2. Click on New Connection and sign in on your Google account.

   

   Fig. 40 Sign into your Google account

3. The system will ask you for some permissions. Once you allow Mammoth to read the files, the connection will be set.

   

   Fig. 41 Allow Mammoth to read and download your sheets

Note

Only project admins can create new connections. Check out Roles & Permissions in Mammoth for more information.

Choosing files to import

1. Once the connection is established, click on your account.

   

   Fig. 42 Choose the account

2. Now enter the URL to the file you want to import in the Enter file URL field.

3. Enter the Google Sheet’s name in the Sheet name field.

4. If you want to import all columns as text columns, tick the option Treat all column types as text.

5. Click on Next.

   

   Fig. 43 Fetching file via URL

Note

The system only accepts files generated as Google Sheets. To upload files not originally created as Google Sheets, use the Google drive integration instead.

Scheduling future data pulls

You can start retrieving the data now or at a specific time according to your choice. You can also schedule the data pull in order to get the latest data from your Database at a certain time interval - just once, daily, weekly or monthly.

On every data pull from your Database, you also have options to - Replace all data or Combine with older data.