--- title: "Connect Google Analytics to Microsoft SharePoint - APIANT.ai" description: "When \"New Daily Report Row\" fires in Google Analytics, your agent runs \"Ensure User\" in Microsoft SharePoint." canonical: "https://apiant.ai/connect/google-analytics-2-to-microsoft-sharepoint" --- # Connect Google Analytics to Microsoft SharePoint When **New Daily Report Row** fires in [Google Analytics](https://apiant.ai/connections/google-analytics-2), your agent runs **Ensure User** in [Microsoft SharePoint](https://apiant.ai/connections/microsoft-sharepoint). Describe the whole flow and it is built, tested on every scenario and kept running. Google Analytics **1** trigger Google Analytics **7** actions Microsoft SharePoint **15** actions What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it. ## What do you want Google Analytics and Microsoft SharePoint to do together? Give your AI client this address. `https://mcp.apiant.ai` One connection does both: ask your client to act in an app once, or have it build an automation that keeps running. Any client that takes a remote MCP server. Nothing to install. Create your free account, then sign in once in your browser. ### Set it up in your client ### Claude Code Run this in the directory you want to work in. `claude mcp add --transport http -s project apiant-ai https://mcp.apiant.ai` Start Claude Code there, approve the server, and sign in in the browser page it opens. [Claude Code guide (opens in a new tab)](https://apiant.ai/docs/mcp/claude-code) ### Claude, web and desktop Open Customize, then Connectors, then Add custom connector, and paste the address. On Team and Enterprise an owner adds it first. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) ### Cursor Add the address to your MCP configuration as a server URL. Cursor signs you in in your browser. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) ### Zed Open Settings, then AI, then MCP Servers, then Add Server, then Add Remote Server. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) ### Codex and the ChatGPT desktop app Open Settings, then MCP servers, then Add server, and choose Streamable HTTP. From the terminal, Codex takes the address with its own add command and then signs you in. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) ### Any other MCP client Paste the address where the client asks for a remote MCP server URL, and name the server apiant-ai where it lets you. APIANT's skills reach the client over the same connection. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) Example flows ## What Google Analytics can start in Microsoft SharePoint - When **New Daily Report Row** in Google Analytics then **Ensure User** in Microsoft SharePoint - When **New Daily Report Row** in Google Analytics then **Sharepoint Create List Item** in Microsoft SharePoint Starting points drawn from the triggers and actions in the catalog today. Describe the flow you need, at any depth, and your agent builds it and tests every scenario before it ships. Everything your agent can do with Google Analytics and Microsoft SharePoint ## Triggers and actions 1 trigger · 22 actions - Trigger **New Daily Report Row** Triggers once for each report row of the previous full day (in the property's time zone), with the chosen dimensions and metrics as fields. Checks for yesterday's rows on every poll and delivers each row once. - Action **Get Metadata** Returns the dimensions and metrics available for reporting on a GA4 property, including custom ones. - Action **Get Property** Returns the details of one GA4 property, such as its name, time zone and currency. - Action **List Accounts** Returns the Google Analytics accounts the connected user can access. - Action **List Audiences** Returns the audiences defined on a GA4 property. - Action **List Properties** Returns the GA4 properties under an account. - Action **Run Realtime Report** Runs a GA4 realtime report covering the last 30 minutes of activity on a property. - Action **Run Report** Runs a GA4 report for the chosen dimensions, metrics and date range and returns one row per dimension combination. - Action **Ensure User** Ensures a user exists in a SharePoint site by their login name. If the user already exists, returns their info; if not, adds them to the site — this is a write operation with a provisioning side effect, not a read-only presence check. Use when you need to add a user or get their user ID for permissions. The login name must be in SharePoint claims format (e.g., 'i:0#.f|membership|user@domain.com'). This action only registers the user in the site collection and does not grant any permissions. To assign list-level access, pass the returned Id field as principal_id to SHARE_POINT_ADD_ROLE_ASSIGNMENT_TO_LIST. - Action **Get Changes** Tool to retrieve changes from SharePoint list change log. Use when processing webhook notifications to get actual changes that occurred. Set boolean flags in query (Add, Item, Update, etc.) to filter change types. Store the ChangeToken from the last change and use as ChangeTokenStart in subsequent calls to track only new changes. - Action **Get Content Type** Tool to retrieve a single SharePoint content type by its ID. Use when you need detailed information about a specific content type including its fields, forms, and metadata. - Action **Get List Field** Get one field definition from a SharePoint list by field GUID or exact internal name/title. - Action **Get Site Page Content** Tool to retrieve modern SharePoint Site Pages content by reading list item fields. Use when a.aspx page result cannot be downloaded as a file or when you need the structured content (CanvasContent1, LayoutWebpartsContent) of modern pages. - Action **List List Views** List saved views for a SharePoint list selected by GUID or exact title, with optional OData projection, filtering, sorting, and offset pagination. - Action **List Scoped Role Assignments** List principals and expanded permission-level bindings on a SharePoint list or list item. The delegated user must have a permission level containing Enumerate Permissions on the selected resource. - Action **Resolve Sharing Link** Resolve a SharePoint sharing URL or provider share token to its underlying drive item. Provide exactly one of sharing_url or share_token. - Action **Sharepoint Create Folder** Creates a new folder in sharepoint using the rest api. - Action **Sharepoint Create List** Creates a new list in sharepoint using the rest api. - Action **Sharepoint Create List Item** Creates a new item in a sharepoint list. - Action **Sharepoint Create User** Creates a new user in sharepoint. - Action **Sharepoint Find User** Finds a user in both microsoft graph and sharepoint to verify their existence and status. - Action **Sharepoint Remove User** Removes a user from sharepoint. will not fail if user doesn't exist. - Action **Update Site** Tool to update properties of the current SharePoint site (web). Use when you need to modify site title, description, or other SP.Web properties via MERGE. ## Each app on its own - [ **Google Analytics** Google Analytics 4 measures website and app traffic, user behavior and conversions; run reports and read...](https://apiant.ai/connections/google-analytics-2) - [ **Microsoft SharePoint** SharePoint is a Microsoft platform for document management and intranets, enabling teams to collaborate...](https://apiant.ai/connections/microsoft-sharepoint) Reviews ## What our customers say ## More from Google Analytics - [ **Google Analytics to ScrapingAnt** ScrapingAnt is a web scraping tool that handles proxies and headless browsers.](https://apiant.ai/connect/google-analytics-2-to-scrapingant) - [ **Google Analytics to HubSpot** HubSpot is your all-in-one stop for all of your marketing software needs.](https://apiant.ai/connect/google-analytics-2-to-hubspot) - [ **Google Analytics to Salesforce** Salesforce is a leading enterprise customer relationship management (CRM) platform.](https://apiant.ai/connect/google-analytics-2-to-salesforce) - [ **Google Analytics to Slack** Slack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...](https://apiant.ai/connect/google-analytics-2-to-slack) - [ **Google Analytics to Google Sheets** Google Sheets](https://apiant.ai/connect/google-analytics-2-to-google-sheets) - [ **Google Analytics to Google Calendar** Google Calendar is a time management tool providing scheduling features, event reminders, and integration...](https://apiant.ai/connect/google-analytics-2-to-google-calendar) ## More into Microsoft SharePoint - [ **HubSpot to Microsoft SharePoint** HubSpot is your all-in-one stop for all of your marketing software needs.](https://apiant.ai/connect/hubspot-to-microsoft-sharepoint) - [ **Salesforce to Microsoft SharePoint** Salesforce is a leading enterprise customer relationship management (CRM) platform.](https://apiant.ai/connect/salesforce-to-microsoft-sharepoint) - [ **Slack to Microsoft SharePoint** Slack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...](https://apiant.ai/connect/slack-to-microsoft-sharepoint) - [ **Google Sheets to Microsoft SharePoint** Google Sheets](https://apiant.ai/connect/google-sheets-to-microsoft-sharepoint) - [ **Gmail to Microsoft SharePoint** Gmail is Google’s email service, featuring spam protection, search functions, and seamless integration with...](https://apiant.ai/connect/gmail-to-microsoft-sharepoint) - [ **Google Calendar to Microsoft SharePoint** Google Calendar is a time management tool providing scheduling features, event reminders, and integration...](https://apiant.ai/connect/google-calendar-to-microsoft-sharepoint) Questions ## Google Analytics and Microsoft SharePoint, answered ### ### What can start an automation from Google Analytics? Any of Google Analytics's 1 trigger in the catalog, including New Daily Report Row. Describe the moment in plain language and your agent picks the right one. ### ### What can your agent do in Microsoft SharePoint when something happens in Google Analytics? Any of Microsoft SharePoint's 15 actions, including Update Site, Ensure User, Get Changes and Get Content Type. Your agent maps the data both ways and tests every scenario before it ships. ### ### Can it also run from Microsoft SharePoint to Google Analytics? Microsoft SharePoint has no triggers in the catalog today, so automations start in Google Analytics. If you need the other direction, ask: your agent reads Microsoft SharePoint's API documentation and adds it. ### ### Do I have to build a connector for Google Analytics or Microsoft SharePoint? No. Both are in the catalog with their triggers and actions. You describe the automation; your agent builds it, tests every scenario and keeps it running. ### ### Can my AI client use Google Analytics and Microsoft SharePoint without building an automation? Yes. With your AI client connected to APIANT, ask it to do something in either app once and it runs that action on the spot. Ask for an automation and your agent builds it, tests every scenario and keeps it running. One connection covers both. ### ### What happens when something fails? Your agent works that out for you. It plans the failure paths along with the happy path, then tests every scenario before it ships. ### ### Is there a free plan? Yes. Every plan includes the agent, including free, and building from your own AI client spends no assistant credits.