Google Analytics, Search Console, Sheets and Drive
GA4 reports, Search Console data, Sheets and Drive files. 18 tools: 14 read, 4 write.
| Tool | Access | What it does |
|---|---|---|
nc_ |
read | List all GA4 properties accessible via the Google connection. |
nc_ |
read | Run a GA4 Data API report for a property. |
nc_ |
read | Convenience: top pages by sessions (or another metric) for a GA4 property and date range. |
nc_ |
read | Convenience: source/medium + channel group breakdown for a GA4 property and date range. |
nc_ |
read | Current realtime active users on a GA4 property, plus top pages by active users right now. |
nc_ |
read | List all sites verified in Google Search Console for this Google connection. |
nc_ |
read | Query Google Search Console search analytics: clicks, impressions, CTR, position. |
nc_ |
read | Convenience: top search queries by impressions (or clicks) for a GSC site and date range. |
nc_ |
read | Inspect indexing status of a URL in Google Search Console: coverage state, last crawl date, mobile usability issues. |
nc_ |
read | List Google Sheets spreadsheets accessible via the Google connection. |
nc_ |
read | Read a cell range from a Google Sheets spreadsheet. |
nc_ |
write | Append rows to a Google Sheets spreadsheet after the last row with data. |
nc_ |
write | Overwrite a specific cell range in Google Sheets. |
nc_ |
write | Create a new Google Sheets spreadsheet. |
nc_ |
read | List the Google Drive files NexaCloser can open: ones it created or that the user picked in Google Drive (drive.file access, not the whole Drive). |
nc_ |
read | Get metadata for a specific Drive file: name, mimeType, size, createdTime, modifiedTime, parents, webViewLink. |
nc_ |
read | Download Drive file content. |
nc_ |
write | Create a new folder in Google Drive. |
nc_google_ga4_list_properties
Section titled “nc_google_ga4_list_properties”read Works with mcp:read.
List all GA4 properties accessible via the Google connection. Returns property IDs and display names. Requires analytics.readonly scope — if missing, returns reconnect_required.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | connections.id for a service=google OAuth connection. |
nc_google_ga4_run_report
Section titled “nc_google_ga4_run_report”read Works with mcp:read.
Run a GA4 Data API report for a property. Returns rows with dimension + metric values. Useful for sessions, users, conversions, pageviews by date/channel/page/country.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | |
property_id |
string | yes | Numeric GA4 property ID (no “properties/” prefix). |
dimensions |
string[] | yes | e.g. [“sessionDefaultChannelGroup”,“date”] |
metrics |
string[] | yes | e.g. [“sessions”,“activeUsers”,“conversions”] |
start_date |
string | yes | YYYY-MM-DD or “30daysAgo” |
end_date |
string | yes | YYYY-MM-DD or “today” |
row_limit |
integer | Default: 1000 · Min 1 · Max 100000 |
|
order_by_metric |
string | Optional metric name to order by descending. |
nc_google_ga4_top_pages
Section titled “nc_google_ga4_top_pages”read Works with mcp:read.
Convenience: top pages by sessions (or another metric) for a GA4 property and date range.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | |
property_id |
string | yes | |
start_date |
string | yes | |
end_date |
string | yes | |
metric |
string | One of: sessions, conversions, activeUsers, screenPageViews · Default: "sessions" |
|
row_limit |
integer | Default: 25 · Min 1 · Max 100 |
nc_google_ga4_traffic_sources
Section titled “nc_google_ga4_traffic_sources”read Works with mcp:read.
Convenience: source/medium + channel group breakdown for a GA4 property and date range. Returns sessions, activeUsers, conversions per channel.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | |
property_id |
string | yes | |
start_date |
string | yes | |
end_date |
string | yes | |
row_limit |
integer | Default: 25 · Min 1 · Max 100 |
nc_google_ga4_realtime_users
Section titled “nc_google_ga4_realtime_users”read Works with mcp:read.
Current realtime active users on a GA4 property, plus top pages by active users right now.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | |
property_id |
string | yes |
nc_google_gsc_list_sites
Section titled “nc_google_gsc_list_sites”read Works with mcp:read.
List all sites verified in Google Search Console for this Google connection. Returns siteUrl and permissionLevel.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes |
nc_google_gsc_search_analytics
Section titled “nc_google_gsc_search_analytics”read Works with mcp:read.
Query Google Search Console search analytics: clicks, impressions, CTR, position. Dimensions: query, page, country, device, date.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | |
site_url |
string | yes | GSC property URL, e.g. “https://example.com/” or “sc-domain:example.com”. |
start_date |
string | yes | YYYY-MM-DD |
end_date |
string | yes | YYYY-MM-DD |
dimensions |
string[] | Items: query, page, country, device, date, searchAppearance · Default: ["query"] |
|
query_filter |
string | Filter rows to queries containing this string. | |
row_limit |
integer | Default: 1000 · Min 1 · Max 25000 |
|
start_row |
integer | Default: 0 · Min 0 |
nc_google_gsc_top_queries
Section titled “nc_google_gsc_top_queries”read Works with mcp:read.
Convenience: top search queries by impressions (or clicks) for a GSC site and date range.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | |
site_url |
string | yes | |
start_date |
string | yes | |
end_date |
string | yes | |
order_by |
string | One of: impressions, clicks, position, ctr · Default: "impressions" |
|
row_limit |
integer | Default: 50 · Min 1 · Max 500 |
nc_google_gsc_index_coverage
Section titled “nc_google_gsc_index_coverage”read Works with mcp:read.
Inspect indexing status of a URL in Google Search Console: coverage state, last crawl date, mobile usability issues.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | |
site_url |
string | yes | GSC property the URL belongs to. |
inspection_url |
string | yes | Exact URL to inspect. |
nc_google_sheets_list_spreadsheets
Section titled “nc_google_sheets_list_spreadsheets”read Works with mcp:read.
List Google Sheets spreadsheets accessible via the Google connection.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | |
query |
string | Optional Drive fullText search to filter by name. | |
limit |
integer | Default: 20 · Min 1 · Max 100 |
nc_google_sheets_read_range
Section titled “nc_google_sheets_read_range”read Works with mcp:read.
Read a cell range from a Google Sheets spreadsheet. Returns a 2D array of values. Use A1 notation, e.g. “Sheet1!A1:D10”.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | |
spreadsheet_id |
string | yes | |
range |
string | yes | A1 notation range, e.g. “Sheet1!A1:E20”. |
nc_google_sheets_append_row
Section titled “nc_google_sheets_append_row”write Needs mcp:write on an OAuth or MCP-server token.
Append rows to a Google Sheets spreadsheet after the last row with data. Values is a 2D array. Writes an audit row.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | |
spreadsheet_id |
string | yes | |
range |
string | yes | Range indicating the sheet to append to, e.g. “Sheet1!A:A”. |
values |
array[] | yes | 2D array: [[“Row1Col1”,“Row1Col2”],[“Row2Col1”,“Row2Col2”]] · Min items 1 |
nc_google_sheets_update_cells
Section titled “nc_google_sheets_update_cells”write Needs mcp:write on an OAuth or MCP-server token.
Overwrite a specific cell range in Google Sheets. Values is a 2D array matching the range. Writes an audit row.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | |
spreadsheet_id |
string | yes | |
range |
string | yes | A1 notation range to update, e.g. “Sheet1!B2:D4”. |
values |
array[] | yes | Min items 1 |
nc_google_sheets_create_spreadsheet
Section titled “nc_google_sheets_create_spreadsheet”write Needs mcp:write on an OAuth or MCP-server token.
Create a new Google Sheets spreadsheet. Optional sheet (tab) names. Returns spreadsheetId and URL. Writes an audit row.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | |
title |
string | yes | |
sheets |
string[] | Optional tab names. Default: [“Sheet1”]. · Default: [] |
nc_google_drive_list_files
Section titled “nc_google_drive_list_files”read Works with mcp:read.
List the Google Drive files NexaCloser can open: ones it created or that the user picked in Google Drive (drive.file access, not the whole Drive). Supports Drive query syntax and MIME type filter. Returns id, name, mimeType, modifiedTime, size, webViewLink.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | |
query |
string | Drive search query, e.g. “name contains ‘report’”. | |
mime_type |
string | Optional MIME type filter, e.g. “application/pdf”. | |
limit |
integer | Default: 20 · Min 1 · Max 100 |
nc_google_drive_get_file_metadata
Section titled “nc_google_drive_get_file_metadata”read Works with mcp:read.
Get metadata for a specific Drive file: name, mimeType, size, createdTime, modifiedTime, parents, webViewLink.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | |
file_id |
string | yes |
nc_google_drive_download_file_content
Section titled “nc_google_drive_download_file_content”read Works with mcp:read.
Download Drive file content. Text files returned as text; binary as base64. Google Docs/Sheets/Slides are exported as plain text/CSV. Capped at 5MB.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | |
file_id |
string | yes |
nc_google_drive_create_folder
Section titled “nc_google_drive_create_folder”write Needs mcp:write on an OAuth or MCP-server token.
Create a new folder in Google Drive. Optionally nest inside a parent folder. Writes an audit row.
| Argument | Type | Required | Description |
|---|---|---|---|
connection_id |
string | yes | |
name |
string | yes | |
parent_id |
string | Optional parent folder ID. Omit to create in My Drive root. |