Create a google sheet and use rows and columns

[rejoo]

Good morning,

I’m new to make.com
and I appreciate the possibilities that we can do with make.com

I have a request to know if we can do this type of scenario with make.com

I want to create a Googlesheet, then ask chat gpt (my assistant) to prepare ideas for a blog, social networks and email, to copy onto the Googlesheet that I created and send it to me by email (to my gmail)

For the moment I can do this with this scenario → Capture%20d%E2%80%99e%CC%81cran%202024-01-18%20a%CC%80%2022.25.16.png - Droplr

the googlesheet link that I receive is created this way →

this way everything works fine.

What I want is to receive like here →

line by line well structured is it possible?

on make.com is there a way to do it like that?
I think I should do column or cell mapping but I couldn’t find which module to choose on make.com and I don’t even know if it’s possible.

If it’s possible can you give me some ideas so I can test?

thanks

[samliew]

Hi @rejoo

Welcome to the Make community!

You are uploading a single row with all the data.

What you want to do is to use an Iterator module, and split the text by newlines so it becomes one row of text per line.

[rejoo]

Hello @samliew
and thank you for the welcome

I tried to add the “Iterator” module
img → Capture%20d%E2%80%99e%CC%81cran%202024-01-19%20a%CC%80%2008.37.47.png - Droplr

however in the final result he sent me 5 emails with the same content but also in the googlesheet file he duplicated the elements 5 times
see image → Capture%20d%E2%80%99e%CC%81cran%202024-01-19%20a%CC%80%2008.39.57.png - Droplr

here are the elements of my open ai module → Screen Shot 2024-01-19 at 08.43.20.png - Droplr

the output result → Screen Shot 2024-01-19 at 08.44.30.png - Droplr on the open ai module
the output result of the iterator module → Capture%20d%E2%80%99e%CC%81cran%202024-01-19%20a%CC%80%2008.45.05.png - Droplr

THANKS

[samliew]

Hello @rejoo,

If you need further assistance, can you please upload the images on this forum?

You can upload images here using the Upload icon in the text editor:

Thank you

[rejoo]

Hello @samliew

I noted your recommendation for the image attachment

I forgot to update the excel module after the iterator module see image

I have no more duplicates in my excel file, it displays the result line by line

However when I receive the email with the Googlesheet link I receive it several times in my gmail inbox.

Example

if I say give me 5 animal names he sends me the email 5 times at the end of the scenario, if I say give me 3 days of the week he sends me the same email 3 times.

I don’t know if I’m wrong but here is the last email request module with link, see image

an idea maybe?

thanks

[rejoo]

Good morning,

I found the solution
this topic helped me a lot →

Email triggered multiple times

Hi, I Watch a Google sheet for new rows Once a row is added I’m triggering an email to all the emails inside the cell “Email” The data looks as follow: email@gmail.com,email1@gmail.com So I’m using the “Map” option and defined the Formula split(Cell;,) Which working fine, The problem is that instead of sending 1 email to each of them, it sends 3 emails to each one of them. What am I missing? [image] [image] [image]

We need to add an Array Aggregrator module before sending the email

[rejoo]

Good morning,
I have another small question with the initial problem,
as @samliew to mention how I can put the information line by line
here →

I would also like to know if I can replace the ; and add the value in column B

let me explain, I ask Chat gpt to give me
3 animal names and color but must be separated by -

example

NAME-COLOR
Fox-Brown
Gray Mouse

the result is →

except I want that if possible

an idea?

thanks for all

[samliew]

@rejoo

let me explain, I ask Chat gpt to give me
3 animal names and color but must be separated by -

Can you actually get the OpenAI module to return that? I’ll need to see it first, so get this for me:

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module and select “Download output bundles”.

A.

Save the bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.
Uploading it here will look like this:

bundle.txt (12.3 KB)

B.

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

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

  ```
  <sup>input/output bundle content goes here</sup>
  ```

• Or use the format code button in the editor:
  

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

This will allow others to better assist you. Thanks!

While it’s tempting to hop onto an existing thread, a more effective approach would be to start a new topic just for your new question. It helps community experts find and respond to your query quicker, and keeps our space organised for everyone. If you start a new conversation you are also more likely to get help from other users. You can refer others back to a related topic by including that link in your question. Thank you for understanding and keeping our community neat and tidy.

The “New Topic” link can be found in the top-right of the header:

[rejoo]

Yes with the open ai module we can ask that, I prefer to ask everything in the same prompt then if we can adjust it will be good (that way we avoid 2,3 steps with google sheet, opening, reading, watching etc… it This is a possibility that I have in reserve to test)

the rest of the problem here →

Create a google sheet file add the content line by line and column by column

Good morning, I already opened a topic here, but I prefer to open a new topic to better focus on the problem. My goal is to create a scenario, for summary → Create a Google Sheet file Make a request with Open AI Fill out the Google sheet Send by email This whole process works well. I managed to add the values line by line with the help of @samliew with this code → [Capture d’écran 2024-01-19 à 14.45.45] in the iterator module. I can now have my data line by line. What I want now …