Gigasheet and Microsoft Reports Integration
Demonstration of how apps are integrated in WEXTL workflow builder[4]
Keep Gigasheet and Microsoft Reports matched by integrating their events and actions. When analytics events happen in Gigasheet, update the Microsoft Reports automatically - without any line of code in visual workflow builder.
- 3-day trial
- Cancel anytime
- Up to 10 minutes quick set up
- GDPR
- Data Encryption
- 2FA
- Local Data Region
Learn about Gigasheet and Microsoft Reports
Detailed info you need to know about Gigasheet and Microsoft Reports integrations in WEXTL. Explore which modules apps support and how you connect them.
Gigasheet

Upload, clean, query and export large spreadsheets in Gigasheet.[5]
Microsoft Reports

Microsoft Graph reports for directory and usage analytics.[6]
How to connect Gigasheet to Microsoft Reports
Set up your Gigasheet and Microsoft Reports integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.
STEP 1
Connect Gigasheet and Microsoft Reports
Save credentials in WEXTL once. We store them encrypted and reuse the authorization across every workflow[3]. No coding or API skills required.
STEP 2
Build a workflow
Paste selected Gigasheet and Microsoft Reports nodes onto the canvas[4], or describe what you want and WEXTL wires the flow together with AI Builder.
STEP 3
Map your data
Choose which fields need to sync between Gigasheet and Microsoft Reports. Use filters or a JS custom code step in between. Everything is on the canvas.
How does the integration between Gigasheet and Microsoft Reports work in WEXTL?
WEXTL exposes actions and triggers for Gigasheet and Microsoft Reports that help you connect apps and automate repetitive tasks[1]. A trigger is an event that happens, and an action is a step that performs when the event has occurred.
Gigasheet triggersMicrosoft Reports actions
Gigasheet modules
- Watch Callbacks Starts a workflow when Gigasheet calls its callback address after an upload or export finishes. Each call brings its Handle and Message.
- Add a Geolocation Looks up the geolocation of each IP address in a column. Uses one API call. Drawn from your plan.
- Add an Iterator Column Numbers the rows in a new column called Column Name. Use Filter Model to number only matching rows and Sort Model to number them in a chosen order. Takes one API call. Billed to your plan.
- Add Conditional Labels Builds a new column whose labels come from the Cases, written as a JSON list. Use Output Column to name it and Default Label for rows that match no case. Costs one API call. Deducted from your plan.
- Append Rows Adds rows to the bottom of a sheet from the Body (JSON). Use Append Rows by Column Name when your rows are keyed by column name. Uses one API call. Taken off your plan.
- Append Rows by Column Name Adds rows to the bottom of a sheet from the Body (JSON), keyed by column name. Bills one API call. Deducted from your plan.
- Append Rows from Another Sheet Copies every row of a Source Sheet onto the end of a Target Sheet. Turn on Add Unmatched Columns to keep columns only the source has, and Trim Column Names to ignore extra spaces in headings. Spends one API call. Drawn from your plan.
- Apply HTTP Enrichment Runs a custom HTTP enrichment over a sheet with the Request Settings. Follow the task with Get HTTP Enrichment Status. Draws one API call. Counted on your plan.
- Build an AI Formula Turns a plain-language Prompt into a Gigasheet formula for a sheet and returns the Formula text. Charges one API call. Drawn from your plan.
- Cancel an HTTP Enrichment Stops a custom HTTP enrichment that is still running. One API call each. Charged to your plan.
- Change Case Use Case to turn every value of a column into upper case, lower case, capitalized or proper case text. Takes one API call. Counted on your plan.
- Change Column Type Converts a column to the new Cast Type. Use Cast Format to add the format that goes with that type. Costs one API call. Billed to your plan.
- Chat with Sheet Assistant Sends a Message to the AI assistant attached to a sheet and gets its answer about that data. Spends one API call. Taken off your plan.
- Check a Formula Tests whether a Formula is valid for the sheet before you run it. Takes one API call. Billed to your plan.
- Check Combine Files Dry-runs a combine of the Sheets and returns every error found, without creating anything. Costs one API call. Deducted from your plan.
- Check Combine Files by Name Dry-runs a combine of the Sheets by column name and returns every error found, without creating anything. One API call each. Taken off your plan.
- Check Email Format Tests whether each value of the Email Column is a correctly formed address. Spends one API call. Counted on your plan.
- Check Federated Table Tests whether the Members can form a federated table before you create one. Add a File Name and Parent Folder to try the exact target. Uses one API call. Charged to your plan.
- Check Source Availability Reports whether a chosen Connector source can be reached right now, returning Is Available. Bills one API call. Billed to your plan.
- Clean Company Names Standardizes the company names held in a column using the Gigasheet cleaner. Draws one API call. Drawn from your plan.
- Combine Columns Joins the values of several Columns, in order, under a new heading called Name. Put Separator text between the values. Charges one API call. Taken off your plan.
- Combine Files Merges the Sheets in order into a new sheet. Use Folder to place it, In Place to combine into the first sheet, and Add Input File Name to add the source sheet name as a column. One API call each. Deducted from your plan.
- Combine Files by Name Merges several Sheets by matching column names into a sheet called New Sheet Name. Turn on Case Insensitive and Trim Column Names to match headings more loosely. Costs one API call. Counted on your plan.
- Copy a File Duplicates a sheet or folder under File Name. Use Folder to place the copy, Recursive to copy the content of a folder too, and Copy State to copy a sheet state of your choosing. Takes one API call. Drawn from your plan.
- Count Activity Totals the activity entries on a sheet. Narrow them by Actions, Categories, Users or a Query, and bound them with Start and End. Spends one API call. Charged to your plan.
- Count Duplicate Rows Reports how many rows repeat across the chosen Columns. Run it ahead of Delete Duplicate Rows to see the impact. Uses one API call. Deducted from your plan.
- Count Groups Gives the number of groups formed by the Group Columns, limited to rows that pass a Filter Model. Bills one API call. Counted on your plan.
- Count Rows Returns how many rows a sheet holds, or only the ones that satisfy a Filter Model. Gigasheet bills one API call for each count.
- Create a Blank Sheet Makes an empty sheet called File Name with a set number of Columns and Rows. Turn on Upload to Team to add it to the team library. Draws one API call. Taken off your plan.
- Create a Connection Registers a data connection for a Connector from the Parameters it needs. Charges one API call. Charged to your plan.
- Create a Connector Source Adds a source such as hubspot to a connector from its Parameters, plus a Code, Org or User if the source asks for them. Uses one API call. Billed to your plan.
- Create a Federated Table Builds one federated table called File Name from several sheets. Use Members to list them and Parent Folder to store the table in a folder. Costs one API call. Drawn from your plan.
- Create a File Entry Adds an entry called File Name to the library. Turn on Skip Type Inference to keep every column as text and Skip Notification to stop the email. Takes one API call. Taken off your plan.
- Create a Folder Adds a folder called Name to your Gigasheet files, inside a Parent Folder when one is set. Its Handle is returned. Each run costs one API call on your Gigasheet plan.
- Create a Linked Sheet from a View Creates a linked sheet from a View, called Name and filed under Parent Folder. The Handle of the new sheet is returned. Spends one API call. Deducted from your plan.
- Create a View Saves a view of a sheet under Name, taking its layout from the client state with the Client State ID. Bills one API call. Drawn from your plan.
- Create an Export Starts exporting a sheet using the Grid State filters, sort and grouping. Use Row Limit to export only the first rows, Records per File to split the output, and Callback URL to be told when it finishes. One API call each. Billed to your plan.
- Delete a Column Deletes the chosen Column of a sheet. Charges one API call. Deducted from your plan.
- Delete a Connector Source Removes a data source that was attached to a Connector. Takes one API call. Charged to your plan.
- Delete a Saved Filter Deletes a filter template saved in your account. Charges one API call. Billed to your plan.
- Delete a Sheet Removes a sheet or folder from your library. Turn on Recursive to delete a folder together with its contents. This cannot be undone. This uses up one API call too.
- Delete a View Deletes the chosen View from a sheet. One API call each. Drawn from your plan.
- Delete Assistant History Deletes the chat log of the sheet assistant for one sheet. Draws one API call. Charged to your plan.
- Delete Columns Removes several Columns from a sheet in one request. One API call each. Counted on your plan.
- Delete Columns by Name Deletes every heading listed under Column Names from a sheet. Costs one API call. Taken off your plan.
- Delete Duplicate Rows Removes every duplicate row across the Columns, leaving one row per set. Use Filter Model to limit which rows are considered and Sort Model to choose which row stays. Spends one API call. Billed to your plan.
- Delete Rows Removes the listed Rows from a sheet. This cannot be undone. Uses one API call. Counted on your plan.
- Delete Rows Matching Filter Deletes all rows that satisfy a Filter Model. This cannot be undone. Bills one API call. Taken off your plan.
- Delete Rows Not Matching Filter Removes every row that fails a Filter Model, leaving only the matches. This cannot be undone. Draws one API call. Deducted from your plan.
- Describe a Sheet Reads the details of one sheet, including its File Name, Owner, Parent Directory and File Rows.
Microsoft Reports modules
- List Directory Audits Reads the directory audit log. Each entry shows its Category, Activity display name, Activity date time, Result, who it was Initiated by and the Target resources it touched. Use Limit to cap the entries.
- List Relying Parties Information Summarizes sign-ins per relying party over the reporting Period. Each entry shows the Relying party name, Successful sign in count, Failed sign in count, Sign in success rate and Migration status. Use Limit to end the list after a set number of parties.
- List User Registration Details Reports how each user is set up for multi-factor authentication (MFA) and self-service password reset (SSPR). Use Is MFA Registered, Is SSPR Enabled or Methods Registered to narrow the report, and User Principal Name to find a single user.
- Make an API Call Makes an authorized free-form request to the Microsoft Reports REST API with your saved credential.
- Retrieve a Directory Audit Fetches one directory audit entry by its Directory Audit ID. The entry has the Category, Correlation ID, Result reason, Logged by service and any Additional details recorded for the activity.
- Retrieve User Features Counts how many users are registered for each authentication feature. Use Included User Types and Included User Roles to count a narrower group. Output includes the Total user count.
- Retrieve User Registration Details Gets the registration record of one user from the User ID. It shows whether the user is an admin, is registered or capable for MFA and SSPR, and is Passwordless capable.
- Retrieve User Registration Methods Counts how many users registered each authentication method. Set Included User Roles or Included User Types to count only one group of users.
Explore alternative integrations
There are other apps[9] supported by WEXTL that can be paired with Gigasheet and Microsoft Reports integrations. Pick any from the list below if the current combination isn't the one you need.
Frequently asked questions
Common questions about connecting Gigasheet and Microsoft Reports.
References
List of sources used to gather information about the Gigasheet and Microsoft Reports integration.
- Gigasheet and Microsoft Reports integration source code, module specs and credentials implementation.
- Our Gigasheet and Microsoft Reports integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for Gigasheet and Microsoft Reports, used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
- WEXTL® visual workflow builder, anonymized data from our technical support team.
- Gigasheet integration information
- Microsoft Reports integration information
- WEXTL® Scheduling
- WEXTL® Pricing and Trial
- WEXTL® Apps Library
How we write our apps documentation
Explore how WEXTL® crafted Gigasheet and Microsoft Reports integration page documentation. Used sources, the role of AI, and how the team validates the result.