Text parser table into google sheet

[fbtjrdn]

hello.
By parsing it using a text parser (Get content HTML table), I got a tab item like the picture below.

However, I am trying to insert this data into Google Sheets, but I cannot check all the data from the text parser in the Google Sheet input data. What should I do?

[samliew]

Welcome to the Make community!

When you see ARRAY, think ITERATOR.

Basically you’ll need to Iterate the “Rows” array variable.

Then, in each Google Sheets column field, you can use the built-in function get

e.g., assuming Iterator is module [79]:

{{ get(79.columns; 1) }}
{{ get(79.columns; 2) }}
{{ get(79.columns; 3) }}
{{ get(79.columns; 4) }}

For more information, see “Mapping with arrays” below:

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
• Discord Server – join us in live chat for fans of Make!

Help Center Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• 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

samliew – request private consultation

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