How to create a spreadsheet from a template and populate it with extracted records

[Fedor_Levikov]

Hey everyone,

I’m working on an automation workflow where we pull data from Apollo Scraper. For each scrape, we want to:

1. Create a new Google Sheets file from a template
2. Populate that new file with multiple records from the scrape

The issue I’m running into is that instead of adding all the records into a single sheet, the automation creates 20 individual sheets, each with one record in it.

I’m not sure how to fix this behavior. Ideally, I want all the scraped records to go into one sheet (tab) inside the newly created file.

Any ideas or suggestions would be super helpful. Thanks in advance!

[ponvaskon]

Hi @Fedor_Levikov

1. Can you place the Create a Spreadsheet module after the Run an Actor module? It should resolve the duplicate spreadsheet issue.
2. As for adding new rows, please share the JSON of the Get Dataset Item module output.

[Fedor_Levikov]

Hello @ponvaskon thank you for your response.

Place the “Create a spreadsheet from a template” module here? (see image attached)

I have added the JSON output for 20 contacts - which are supposed to be rows in the attachment here as well.

I appreciate your help!

Fedor

JSON export may 28 2025.txt (480.1 KB)

[ponvaskon]

Hi @Fedor_Levikov

Yes, after the Run an Actor module, or if this module returns more than one bundle, after the Jotform module. This replacement should resolve your issue.

[Fedor_Levikov]

Hi @ponvaskon how do I then map the “add row” module to a newly created sheet property?

In the “create a new sheet from template” module it states that i need to create a tag like so {{name}}, at least 1 tag - is that used to map the columns in the sheet?

After I have done that, there is no clear way to map the add row module, as it lists column range, not custom columns for mapping.

Fedor

[ponvaskon]

@Fedor_Levikov

1. Manually add the Spreadsheet ID and Sheet Name of the test spreadsheet, select the column range, and refresh it.
   
   
2. Map the required values.
3. Replace the hard-coded Spreadsheet ID and Sheet Name values with the Create a Spreadsheet module output values.
   
   

[Fedor_Levikov]

Thank you @ponvaskon I will try this later today and get back to you.

Fedor