## Overview
We combine our [Creating a dynamic infographic](/posts/2022-06-24-Automate-creating-an-infographic) and [Using Make as an API for Excel](/posts/2022-07-19-Using-Make-as-an-API-for-Excel) tutorials to show you how to dynamically create an Infographic using your Excel data. 

We use n8n to first hit a Make scenario to get Excel data and then we pass that data to a different n8n workflow to dynamically create an infographic.

[Learn how to dynamically create an infographic with Excel data - YouTube](https://www.youtube.com/watch?v=1osaqdSFRjw)

## Flow
![Mermaid Flow](https://mermaid.ink/svg/pako:eNptkm1rgzAQx7_KkSG00ArdU4svCltbX21sdE9vfBP12gY1cUmkK-J330XdZmGIetz97v6Xu9QsUSmygHleLaSwQR0xe8ACIxZELOaGjAn0vneuBY9zNBQEAkstCq5PK5Ur3fIX81kYhpsuxWCiZHoeD-8Wq_U8Yk3TeF4k3bPXvDzA69rZsVZHg3p03_3HkZQLOaIXCi4kHJXOdrk6dn7RBoTcqbaESIbxgmc4eqQPmAQl9a3GAwGYTmHmw1OJElyRD4wPSmXwtn0Aii2ds9Vw4KUPW_ys0FjYfCWYQ8otbykn0kk57spxttIS8BwbFrv24ZkbM6g0Ad1XHx6lzxPdSV3mjQ8rjdwipCfJC2KGfGWE3JOnrOz_wre_3dHO9ghWUU47iSX0U-n2AcAmrEBNE0_pXtTO83cnyKSVZhGLZENcVZIYblJhlWbBjucGJ4xXVr2cZMICqyv8gdaCU7NFTzXf7rfTmQ)

```mermaidignore
graph TD

browser(Browser)
n8n(n8n main workflow)
n8ni(n8n infographic workflow)
make(Make scenario)

browser -- 1. Open n8n Webhook URL  --> n8n
n8n -- 2. Request Excel data --> make
make -- 3. Return excel data --> n8n
n8n -- 4. Pass Excel data, request infographic --> n8ni
n8ni -- 5. Create dynamic infographic using input data --> n8n
n8n -- 6. Return image to user --> browser
```

## How to recreate this automation
### Resources
- [n8n](https://n8n.io/cloud?ref=tinyautomations&utm_source=affiliate)
- [Make.com](https://www.make.com/en/register?pc=rymawby)
- [Webhooks (make.com)](https://www.make.com/en/help/tools/webhooks?pc=rymawby)
- [Microsoft 365](https://www.office.com)

### Step 1: Create an n8n workflow
Create a new workflow in n8n. Your final workflow will end up looking like this:
![](https://ry.d.pr/wbEMMq.png)

The workflow consists of 4 nodes.
- The first node is the `Webhook` that you call to kick off the workflow.
- The second node (a `HTTP Request`) calls the [Creating a dynamic infographic](/posts/2022-06-24-Automate-creating-an-infographic) workflow and returns Excel data.
- The third node (another `HTTP Request`) calls the [Using Make as an API for Excel](/posts/2022-07-19-Using-Make-as-an-API-for-Excel) n8n workflow whilst passing in the data from the previous node.
- The final node returns the image to the user.

### Step 2: Create a Webhook node
Create a `Webhook` node in your n8n workflow. Set the `Respond` value to `Using 'Respond to Webhook' Node`. This makes sure that the whole workflow will get executed before returning an image combined with Excel data.
![n8n webhook node](https://ry.d.pr/igslKh.png)

### Step 3: Run the Make workflow
Create a `HTTP Request` node that calls your [Make scenario](/posts/2022-06-24-Automate-creating-an-infographic). This will return JSON data of your Excel spreadsheet.
![Call Make node](https://ry.d.pr/HW9Wan.png)

### Step 4: Call your infographic n8n workflow
Create a `HTTP Request` to call your [n8n workflow](/posts/2022-06-24-Automate-creating-an-infographic).
![n8n Infographic HTTP Reequest node](https://ry.d.pr/YO6V5v.png)

You will need to add a query parameter to the URL - you can do this using the expression editor to select the data coming through from Excel as JSON in the previous step. Your expression should look something like this:
![Using the n8n expression editor to dynamically fill your Excel data](https://ry.d.pr/HNnxGn.png)

### Step 5: Return the image to the user
Return the image to the user/browser - you do this by creating a `Respond to Webhook` node with the `Respond With` set to `Binary` and automatically choosing the data source from Input.

![Respond to Webhook n8n node](https://ry.d.pr/99U1YK.png)

Combine 2 of our previous automations to generate dynamic infographics from Excel data

Dynamically create an infographic with Excel data

## Overview
In this automation we get data out of Excel by hitting a URL. In this automation we use [Make's](https://www.make.com/en/register?pc=rymawby) simple and powerful integration with [Microsoft 365](https://office.com).

[Youtube video tutorial](https://www.youtube.com/watch?v=6NQnWKvHAdI)

## Flow
[![](https://mermaid.ink/img/pako:eNptUU1rwzAM_SvCI9BCexhj68hh0LXJ2KD76tjJFydRF5PELrK9roT899lJyjbYRX5I70nPUstyXSCLWRS1Ukkbt5zZEhvkLOYsE8aDGYy5d0FSZDUaXwRP3JNsBB1XutbU888W52maJoPEYK5V8beeLq9X6wVnXddFEVdcfZDYl_C2DjgjfTBIk9vhnXLViAonGx88xq8c60kSImxkTtronYWLq8vpLy3M55Ao60FQwQGzUusKHNW-cgOh39A1EF8c0hGGjp9S_Op617taPt_3qn7yaCDoXtE6UlALY8GPBb2Dg6bKlIj2nzEj_WH79AhWgws2w7iTuaAY7YefALAZa5AaIQt_lzZkfm7ioV9pxRlXnee5fSEsJoW0mli8E7XBGRPO6u1R5Sy25PBEWkvhl92MrO4bRvCrSA)](https://mermaid.live/edit#pako:eNptUU1rwzAM_SvCI9BCexhj68hh0LXJ2KD76tjJFydRF5PELrK9roT899lJyjbYRX5I70nPUstyXSCLWRS1Ukkbt5zZEhvkLOYsE8aDGYy5d0FSZDUaXwRP3JNsBB1XutbU888W52maJoPEYK5V8beeLq9X6wVnXddFEVdcfZDYl_C2DjgjfTBIk9vhnXLViAonGx88xq8c60kSImxkTtronYWLq8vpLy3M55Ao60FQwQGzUusKHNW-cgOh39A1EF8c0hGGjp9S_Op617taPt_3qn7yaCDoXtE6UlALY8GPBb2Dg6bKlIj2nzEj_WH79AhWgws2w7iTuaAY7YefALAZa5AaIQt_lzZkfm7ioV9pxRlXnee5fSEsJoW0mli8E7XBGRPO6u1R5Sy25PBEWkvhl92MrO4bRvCrSA)

```mermaidignore
graph TD

browser(Browser)
make(Make)
excel(Excel Microsoft 365)

browser -- Enter Make webhook url --> make
make -- Query Excel via Microsoft Graph API --> excel
excel -- Return last row of worksheet --> make
make -- Return JSON to user via webhook --> browser

```

## How to recreate this automation
### Resources
- [Make.com](https://www.make.com/en/register?pc=rymawby)
- [Microsoft 365](https://www.office.com)
- [Webhooks (make.com)](https://www.make.com/en/help/tools/webhooks?pc=rymawby)
- [JSON (make.com)](https://www.make.com/en/help/tools/json?pc=rymawby)
- [Graph Explorer | Try Microsoft Graph APIs - Microsoft Graph](https://developer.microsoft.com/en-us/graph/graph-explorer)

### Step 1: Create a new Make scenario
Create a new scenario in Make. Your scenario will end up looking something like this:
![Completed Make scenario](https://ry.d.pr/HA3ixm.png)

## Step 2: Create a Webhook node
In your Make scenarion create a `Custom webhook` node. `Add` a new webhook and give it a name. Copy the address and open it in your browser.
![Create a custom webhook node](https://ry.d.pr/je0KgS.png)


## Step 3: Create an Excel node
Create a new `Make an API Call` node and connect it to your Microsoft account. You need to determine what you put in the `URL` input box by using the [Microsoft Graph Explorer](https://developer.microsoft.com/en-us/graph/graph-explorer) (more info on this can be found in the video).

![Excel Make an API Call node](https://ry.d.pr/L5uFSB.png)

For this demo we fetch the last row of the Excel worksheet by using this path (where `subscribers` was the name of the worksheet):
```
/v1.0/me/drive/items/01NNEVLKRZNF6EMAUUJHKJ2YA5CMDNPY/workbook/worksheets('subscribers')/usedRange/lastRow
```

Our Excel spreadsheet looks like this:
![Excel spreadsheet](https://ry.d.pr/qAiTLX.png)

## Step 4: Convert the retrieved data to JSON
Use a `Transform to JSON` node to convert the data returned from `Step 3` into JSON. Make allows us to click in the `Object` input box and click an input from the previous node. Here we just use the `Body`.
![Transform to JSON node](https://ry.d.pr/GdrSVx.png)

## Step 5: Return the data to the user
Create a `Webhook response` node that returns a `Status` of `200` (this means all is OK) and a `Body` of the `JSON string` from the previous node. Now when you hit the `URL` from `Step 2` you will see the data from your Excel worksheet being returned. 
![Respond to webhook response](https://ry.d.pr/Y7mdMn.png)

This automation can now be used in other automations to access your Excel data.




How to access your Excel data with a URL using Make

How to use Make as an API for Excel

## Automation overview
Nowadays you can be inundated with PDF reports and analysis from various sources and after a quick glance they are never viewed again. Here I show you a way of extracting and saving that data from a PDF you receive in an email into Excel.

[Extract data from a PDF email attachment into Excel using Make - YouTube](https://www.youtube.com/watch?v=yND9qt8JcG0)

## Automation flow for extracting data from PDFs using Make and inputting into Excel

![Data extraction PDF flow](https://mermaid.ink/svg/pako:eNptkE1rwzAMhv-K8Qik0A526shhMJrmNjbY2GH4ojrqYpJYwVFoS8h_n5K0WzeGQX5lPfqwem0pR53oKOqdd5z0RnOBNRqdGL2DVsRSnd_eITjYVdhKUAnYBFdDOG2oojDxN-u7LMu2c0qLlnz-O5493m_StdHDMESR8eP5DNAU6i0dNXVcEZXx83wvjK-hxPhJjOgm31uKX9Ls1pK4eLRYxdvRLq6S1WqlsAZXqYPjQgmugBlsUaNnCT6oseZceWKPHMDyX2hqdu55jeXA8E-VQ3CMc5BJBTpMzDTi_E2l9FLXGGSyXNbdjy8_qxYpmyqNNn4QrmukEm5zxxR0soeqxaWGjun15K1OOHR4gVIHssH6m2rAfxBd_OELTAijEQ)
```mermaidignore
graph TD

outlook(Outlook)
make(Make)
pdfco(PDF.co)
excel(Excel)

outlook -- email with PDF attachment --> make
make -- extract attachment --> pdfco
pdfco -- extract data --> make
make -- write data to row --> excel
```

## How to recreate this automation
### Resources
- [Make | Work the way you imagine](https://www.make.com)
- [PDF.co](https://pdf.co/)
- [Outlook and Excel](https://www.office.com/)

### Step 1: Setup an Outlook rule to move required emails to a folder
Setting this up simplifies the process within Make - as it means we won't need to do any tricky searches on our whole inbox. For this demo I created a folder called `Automation` and moved any messages from my personal email address containing the subject `Channel Stats` into it.

![Outlook Rule](https://ry.d.pr/7FCbAK.png)

### Step 2: Create a Make scenario that extracts email attachments
This is a 3 step process in itself - first of all you find the emails via a search, then you list out the attachments from that email and then finally you download the attachment.

![Three steps to getting the attachment](https://ry.d.pr/UC0C5K.png)

In the `Search Messages` node we want to grab emails from `Today` that are in the `Automation` folder we set up in `Step 1`. 

![Search Messages](https://ry.d.pr/qKrjSH.png)

In the `List Attachments` node we want to use the `Message ID` from the search result in the `Search Messages` node.

![List Attachments Node](https://ry.d.pr/3z2jaH.png)

In the `Download an Attachment` node we want to use the `Message ID` from the search result in the `Search Messages` node and the `Attachment ID` from the `List Attachments` node.

![Download an Attachment Node](https://ry.d.pr/cUdz2h.png)

### Step 3: Extract data using PDF.co
You need to create an account on PDF.co and create a document parser. In this document parser you are able to set up objects that will extract text/data from your PDF. Here you can see how it was set it up for the demo (for more detailed information on how to set this up watch the video above).

![PDF.co Document Parser](https://ry.d.pr/yefVJT.png)

After you save take note of the ID of the Document Parser Template.

![Document Parser Template ID](https://ry.d.pr/ej0VGY.png)

Add your PDF.co node in Make after the `Download an Attachment` node.

![Add your PDF.co node](https://ry.d.pr/Tqhdrh.png)

Set your PDF.co node up so that its `Input File` is `Upload a File` and the `File` is from the previous node. Then add the ID of your `Document Parser Template` that you set up earlier.
![PDF.co node setup](https://ry.d.pr/eD6bz7.png)

### Step 4: Write out the data to Excel
The final step is to write the data you have extracted from your PDF to your Excel spreadsheet. Add `Microsoft 365 Excel Add a Worksheet Row`  node as the final node.
![Microsoft 365 Excel node](https://ry.d.pr/0mP7WO.png)

Setup your node so that it uses the values from PDF.co to write to your spreadsheet (you need to have created your spreadsheet already). The values you set up in your `Document Parser Template` will be available in this node to write to your spreadsheet.

Select your `Workbook` and then your `Worksheet` and the rows you have setup in your spreadsheet will become available.

![Excel node setup](https://ry.d.pr/u2deCS.png)

Automate data extraction from your PDFs using Make and PDF.co and save to Excel

Learn how to automate with Excel