Bundle collection into google sheets

[jral]

Hello,

I am trying to get each of the values in a bundle (collection) added as separate rows in a google sheet. Here is where I’m stuck (see screenshot). can you please advise?

Thanks

Jerry

[kudracha]

Hi @jral, have you tried using ‘iterator’ module with : toArray(Bundle1) config and then ‘sheet add rows’ module based on iterator value ?

edit: even better would be to look before parse json why the data is structured this way and if you can modify the structure ?

[samliew]

Welcome to the Make community!

To allow others to assist you with your scenario, please provide the following:

Relevant Screenshots

Please share screenshots of your Parse JSON module.

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

Scenario Blueprint

Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Input Bundles of Modules

Please provide the input 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 bundles”.

A. Upload as Text File

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

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

• Method 1: Type code block manually

  Add three backticks ``` before and after the content/bundle, like this:

  ```
  <sup>content goes here</sup>
  ```

• Method 2. Highlight and click the format button in the editor

  

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

By providing these details, it will allow others to assist you better.

[jral]

Hi @kudracha thanks for your help!

1. I can’t see the Bundle1 option in the config. What do you advise?
   

   

2. my output from my previous module is in JSON as below. What is a better structure if i want to add the values to a google sheet?
   

   

Thanks!

[jral]

Just confirming I don’t need help with this any longer. My fix - parse json, go through an iterator and merge the different arrays. Once I’ve done that, I push them into google sheets. This solved my problem.