Add new incoming emails to a Google Sheets spreadsheet as a new row

Make (formerly Integromat) will automatically add selected data from new emails to a Google Sheets spreadsheet as new rows. This way, you can easily keep track of all your incoming emails in one place. The template uses this example spreadsheet.

Create a new scenario in Make (formerly Integromat).

Add the Google Sheets > Watch a Spreadsheet module to your scenario.

Select your Google account.

Enter the path to the spreadsheet you wish to watch.

Add the Email > Watch Email module to your scenario.

Select your email account.

Enter the email address from which you want to watch emails.

In the Email module's module settings, select the fields you want to add to your Google Sheet. To add more fields, click the + button.

Add the Google Sheets > Add a Row to a Table module to your scenario.

Select your Google account.

Enter the path to the spreadsheet you wish to update.

In the Add a Row to a Table module's module settings, map the fields from the Email module to the columns in your spreadsheet.

Run your scenario.

Now, whenever you receive a new email, Make (formerly Integromat) will automatically add selected data from the email to a new row in your Google Sheet.

You run a small business and want to keep track of all customer inquiries. By using this scenario template, you can have Make (formerly Integromat) automatically add new customer emails to a Google Sheet, making it easy to track and follow up on customer inquiries.