Data manipulation in Microsoft Excel with automated workflows

• Automate the creation of new worksheets in Microsoft Excel.
• Retrieve and analyze data from existing Excel tables.
• Perform lookups to find specific values in Excel tables.
• Generate random test data for Excel spreadsheets.
• Streamline data management processes in Excel.

Starts the workflow to add a new worksheet in Microsoft Excel. Retrieves all data from specified worksheets. Performs lookups on tables to find specific values. Gets content from specific ranges in worksheets. Generates random data for testing purposes.

1. 1
   Import the workflow template into n8n.
2. 2
   Configure Microsoft Excel OAuth2 credentials.
3. 3
   Customize the workbook ID and table IDs as needed.
4. 4
   Run the workflow to automate data manipulation tasks.