SQL DATABASE and Make

[LOUL]

Good morning,

I would like to extract a store listing from my database and send it to Googlesheet.

I connect to the database and I can clearly see the output results (the 10 store names).

I added the Googlesheet model (addrow) but I cannot find values ​​for the mapping in the Googlesheet.

Can you help me please

[samliew]

Welcome to the Make community!

Your “Rows” variable is an array, so to run each item through the next module, you need to use an Iterator module.

Links

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

General

• Help Center | Tutorials
• Make Academy – learn Make and get your certificate ← CHECK THIS OUT
• Make Blog – get the latest updates
• Features & Pricing

Help Center Basics

• Mapping – What is mapping? What can I map? ← CHECK THIS OUT
• Mapping with arrays – How to map items in an array ← CHECK THIS OUT
• Aggregate an array for mapping complex fields
• Tokens for parseDate | Tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI
• How to use Regex in Make

[LOUL]

Good morning,

Thank you for your reply. I managed to retrieve the elements from my sql query and map them into googlesheet

I would like the column names to appear in the mapping however I requested it.

Can you help me please.