Creating a table in make.com

Questions
, ,
1

:bullseye: What is your goal?

Creating a spreadsheet with multiple rows from iteration

:thinking: What is the problem & what have you tried?

I am attempting to build my first scenario. |The purpose of it is to iterate over multiple documents, AI extracts the key information and I want to create a spreadsheet of this information, where each row is the answers from each document.

I’ve got as far as getting a structured output from the AI. I can add single rows to a spreadsheet but every time the iterator overwrites the row, it doesn’t add to it.

1 Like
3

Hey Jacob,

what module are you using to add the row? Can you show the mapping inside?

4

Hey Stoyan

I’ve attached an image of my scenario so far. I’m trying to just create a table within make which I can then create a spreadsheet from, rather than add a row to the spreadsheet each time the scenario iterates

Thanks

Jacob

image
image1532×199 40.4 KB

1 Like
5

OK so the create excel module is in essence an aggregator module. You need the correct source module for the aggregation to work. I assume that’s the iterator module and not the create JSON one.

3 Likes
6

Yes thanks, I changed the source module to iterator and that’s fixed it

Thanks!

1 Like