How to Automatically Import NewsMAN Statistics into Google Sheets

If you want to create regular reports for your clients, you can automatically import data from NewsMAN into Google Sheets. This gives you all your newsletter, subscriber and automation statistics in one place, without having to export the data manually each time.

Using the NewsMAN API, you can import the following types of statistics into Google Sheets:

• Newsletter statistics – sent newsletters, opens, clicks, unsubscribes, spam reports and other available data;
• Subscriber evolution – new subscribers and unsubscribes over a specific period;
• Automation statistics – aggregated data for the automations in a list.

What you need

To set everything up, you need:

• a NewsMAN account;
• access to the API section of your account;
• a USER_ID, API_KEY and LIST_ID;
• a Google Sheet in Google Drive.

1. Import newsletter statistics into Google Sheets

For newsletter statistics, you can use the newsletter.all API method.

Example URL:

https://ssl.newsman.app/api/1.2/rest/USER_ID/API_KEY/newsletter.all.csv?list_id=LIST_ID&days=90&status=all

Replace USER_ID, API_KEY and LIST_ID with the values corresponding to your account and list.

How to set up Google Sheets

1. Create a Google Sheet in Google Drive.
2. Select the cell where you want the data to appear.
3. Enter the IMPORTDATA formula using the API URL:

=IMPORTDATA("https://ssl.newsman.app/api/1.2/rest/USER_ID/API_KEY/newsletter.all.csv?list_id=LIST_ID&days=90&status=all")

4. If Google Sheets asks for permission to import data from an external source, grant the required access.

The newsletter data will then be imported automatically into the sheet.

What can you use in your report?

The imported data can be used to create regular newsletter performance reports, including metrics such as:

• number of newsletters sent;
• opens;
• clicks;
• unsubscribes;
• spam reports;
• other statistics returned by the API method.

2. Track subscriber evolution

To see how the number of subscribers in a list changes over time, use the list.subscribersEvolution method.

Example:

https://ssl.newsman.app/api/1.2/rest/USER_ID/API_KEY/list.subscribersEvolution.json?list_id=LIST_ID&start_date=2025-05-01&stop_date=2025-05-31

You can define the reporting period using the following parameters:

• start_date – start date;
• stop_date – end date;
• list_id – the list for which you want the statistics.

To use the data in Google Sheets, use the CSV version of the method:

list.subscribersEvolution.csv

Simply replace .json with .csv in the API URL.

The data can then be imported into Google Sheets using the same IMPORTDATA method.

3. Import automation statistics

For automation reports, you can use the:

automation.stats

method.

It allows you to retrieve daily aggregated statistics for:

• all automations in a list;
• or only specific automations.

For Google Sheets, use the CSV format instead of JSON.

For example, if the JSON endpoint is:

automation.stats.json

use:

automation.stats.csv

As with newsletter and subscriber statistics, the CSV URL can be used with the IMPORTDATA formula in Google Sheets.

4. Recommended API formats for Google Sheets

When importing data directly into Google Sheets, use the CSV versions of the API methods:

Statistic type	Method for Google Sheets
Newsletter statistics	newsletter.all.csv
Subscriber evolution	list.subscribersEvolution.csv
Automation statistics	automation.stats.csv

The CSV format allows Google Sheets to import the data directly as a table using the IMPORTDATA function.

5. How often is the data updated?

Once the IMPORTDATA formula is configured, Google Sheets automatically refreshes the imported data. Under normal circumstances, the data may be updated approximately every 15 minutes, although the actual refresh frequency is controlled by Google Sheets and may vary.

This means you do not need to manually export the data every time you create a report.

---

Recommended setup for monthly reports

If you send monthly reports to your clients, you can organize your Google Sheet into several tabs, for example:

• Newsletters – newsletter campaign performance;
• Subscribers – subscriber base evolution;
• Automations – automation performance;
• Report – the key metrics you want to present to your client.

This way, NewsMAN data can automatically feed a centralized report, while Google Sheets can be used for filtering, analysis, charts and presenting the results to your client.

In short

To import NewsMAN statistics into Google Sheets:

1. Copy the API URL corresponding to the statistics you need.
2. Use the .csv version of the method.
3. Create a Google Sheet.
4. Use the IMPORTDATA("API_URL") formula.
5. Grant permission to import external data if requested.
6. Use the imported data for regular reports and analysis.

This allows you to build a simple automated email marketing reporting system, without manually exporting data for each reporting period.