5 diffrent textparser to one row in google sheets

How To
1

Summary of My Make.com Automation and Challenges

Purpose of My Automation

I have created an automation in Make.com with the following steps:

  1. Email Trigger: It starts by detecting new emails in a specific folder.
  2. Attachment Check: It verifies if the email contains any attachments.
  3. Upload to Google Drive: If attachments are found, they are uploaded to a specific folder in Google Drive.
  4. Convert PDF to Images: The PDF attachments are then converted to images.
  5. Image Analysis with OpenAI: The images are analyzed using OpenAI GPT-4 to extract invoice details such as type, invoice number, date, amount, and debtor.
  6. Text Parsing: The output from OpenAI is parsed using several Text Parser modules to extract specific fields.
  7. Google Sheets Integration: The extracted data is intended to be written into a Google Sheets spreadsheet, with each parser’s output being placed in a row.

Challenge

I am encountering an issue where I cannot directly connect the outputs of multiple Text Parser modules to an Array Aggregator in Make.com. Even when I use Set Variable modules to store each Text Parser output, I am still unable to combine these variables into a single array. This limitation is preventing me from aggregating the data from the last five Text Parser modules into a single row for insertion into Google Sheets.

Current Workflow Steps

  1. Text Parser Outputs: Each Text Parser module extracts a specific piece of information from the OpenAI output.
  2. Set Variable Modules: Each Text Parser output is stored in a separate variable.
  3. Aggregation Challenge: Unable to directly aggregate these variables into an array using the Array Aggregator module.
  4. Writing to Google Sheets: Need to write the aggregated outputs as a single row in Google Sheets.

Request for Help

I am looking for guidance on how to effectively aggregate multiple Text Parser outputs, stored as variables, and write them into a single row in Google Sheets within Make.com. Any suggestions or alternative approaches to achieve this would be greatly appreciated.

Thank you in advance for your assistance!

image
image1128Ă—508 51 KB

2

Welcome to the Make community!

Why do you need a router?

You should be able to put everything inline, consecutively one after the other module.

If you need further assistance, please provide the following:

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:
Screenshot_2023-10-07_111039

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Screenshot_2023-08-24_230826
(Note: Exporting your scenario will not include private information or keys to your connections)

Uploading it here will look like this:

blueprint.json (12.3 KB)

3. And most importantly, Input/Output bundles

Please provide the input and output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
Screenshot_2023-10-06_141025

A.

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading them here will look like this:

module-1-input-bundle.txt (12.3 KB)
module-1-output-bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles in this manner:

  • Either add three backticks ``` before and after the code, like this:

    ```
    input/output bundle content goes here
    ```

  • Or use the format code button in the editor:
    Screenshot_2023-10-02_191027

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

samliew – request private consultation

Join the unofficial Make Discord server to chat with other makers!

1 Like