Google Sheets

Save the Gmail data into Google Sheets as per your mapping of headers with Gmail fields

SETTING UP GOOGLE DOCS

SETTING UP GOOGLE SHEETS

  • Select the Google Sheets from list of service
  • provide name of your service
  • provide the Google Sheets URL of your service
  • Select the Action you need

SETTING UP CONFIGURATION

Configuration setup

  • Open an Email
  • Click configure service button
  • Click on Create new
  • Select Google Sheets

SERVICE NAME

  • Service Name is the name provided by you for your service
  • Enter the Service Name
  • GOOGLE SHEETS URL
  • URL need to provided by you that where you need to publish your Mail in Sheets
  • To get Google Sheets Url
    • Open your Google Drive
    • You can create a new Google Sheets or you can open the existing Google Sheets in which you need to save the emails
    • Open the Sheets in browser
    • Copy the web url of the document
    • Paste it in Mail Director's 'Google Sheets Url' field

CHOOSE INFO CARDS

Show number of saved emails

  • Show number of saved emails info card will show the number of saved emails that saved from opened mail's sender(from address)
  • Select the "Show number of saved emails" check box
  • Click save to save the configuration
  • It will show while you open the mail

CHOOSE ACTIONS

SAVE MAIL

  • Save Mail action will save your email into the Google Sheets
  • Select the save check box
  • Click save to save the configuration

SAVE MAIL BY USING SERVICE

Save Mail to Google Docs

Click on Maildirector add-on

Open the mail that need to save

Select the Service of Google Sheets

Clicking on Service Go will open the following fields

              • From
              • Subject
              • Date
              • To
              • Cc
              • Message
  • From

This field has the name or email id of the user who have send the mail.

  • Subject

This field has the subject of the mail.

  • Date

This field has the date in which the mail is received.

  • To

Basically this field has your email address.

  • Cc

This field contains the Cc contents of the mail

  • Message

This field contains the message body

SAVED MAILS

You can see the saved mails by click the Link to Google Sheets