Use this connection to pull emails from Gmail® into Minitab Connect. This connection only pulls unread emails so Connect
doesn't pull duplicate emails each time the connection updates. Gmail marks an email as read
after Connect pulls it.
Set up a new connection
Complete the following steps to set up a connection in Minitab Connect.
- From the Home screen, select the Add button under Tables.
- In Datasets, enter Gmail and select the connector from the results.
- Under Connection Setup, enter a Name that identifies the connection.
- Select Authorize Google. Enter the Google credentials for the account that you want to use. When connected, the button updates to Authorization Successful. Select Save.
After you save the connection, Connect displays options to import data into a new table. Start at step 4 of the following section for more information on importing data to create a table.
Create a table with data from a connection
Complete the following steps to import unread emails from Gmail and create a new table in
Connect.
- From the Home screen, select the Add button under Tables.
- In Datasets, enter Gmail and select the connector from the results.
- Under Connection, select a Gmail connection that you previously set up. If you have not previously set up a connection, select New Connection and follow the steps in the previous section.
- On the left panel, enter a Name that identifies the table and select a Folder to save the table.
- Under Update Frequency, specify how often you want Connect to update the table. You can import the data one time or have Connect continuously import the data at a set time interval. Connect automatically creates a flow for your import. If you select Once, you can use the flow at a later time to automatically run the import again.
- In To and From, enter a single email address to filter the emails that Connect pulls. Connect pulls only unread emails that were sent to or from the address that you enter. You cannot enter multiple email addresses. Leave these fields blank to pull all unread emails.
- In Subject and Body, enter a single string to filter the emails that Connect pulls. Connect pulls only unread emails that contain the entire string in the subject line or body of the email. You cannot filter on multiple strings at once. Leave these fields blank to pull all unread emails.
- From Import Format, select the elements that you want to pull from the email. Connect creates separate fields in the table for the body of the email, attachments, and links. If you select Import links found in body, you can filter the results based on the string you enter in Search term for body links.
- Select Next.
- If you need to execute custom field types, select Yes from Are there Custom Field types that need to be run.
- Select Save
. If you go to the
Prep Tool and select Run
, Minitab Connect
displays the imported data. Note
If no data appears after you select Run, select Reset Config
.
When you save the import, Connect creates a flow with the settings that you selected. For more
information on how to schedule a flow and add more data processes to clean data, go
to Overview of the Flow Tool
.
Export a file
Complete the following steps to export data from a Minitab Connect table.
- Open the Outputs tab of the Flow Tool
.
- Select the plus sign
beside
Export to add a new export. - Under Export, select New Export. If you select One Time Download, Connect downloads the file to your computer and does not create an export.
- Enter a Name for the export.
- Under View, select a saved view of the table. If you select None, Connect exports all the data from the table. For more information on saved views, go to Example of creating a data view.
- Under Delivery, select Connection.
- Under Connection, select the Gmail connection that you previously set up.
You can specify the file type and file name along with other options. Select
Save to add the export to the list of exports in the Outputs tab. Select
Run
to run the export.
