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:
Only project admins can create new connections. Check out Roles & Permissions in Mammoth for more information.
Choosing files to import¶
Once the connection is established, click on your account.
Now enter the URL to the file you want to import in the Enter file URL field.
Enter the Google Sheet’s name in the Sheet name field.
If you want to import all columns as text columns, tick the option Treat all column types as text.
Click on Next.
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.