Add Rows In a Newly Created Excel Sheet

[Cameron_Williams]

Description

The user is experiencing difficulties when trying to automate the output of a content schedule in a spreadsheet. The current process requires the user to map the spreadsheet ID manually, which is not user-friendly and hinders the automation workflow.

Steps to Reproduce

1. Attempt to create a spreadsheet for a content schedule automation.
2. Try to add a row to the spreadsheet using the automation module.
3. Observe that the system prompts for a spreadsheet ID in a way that requires manual mapping.
4. Note that the user is unable to directly map the spreadsheet ID without choosing a file.

Acceptance Criteria

• Users should be able to add rows to a spreadsheet without needing to manually map the spreadsheet ID.
• The automation should allow for direct mapping of the spreadsheet ID from the existing spreadsheet.
• The process should be streamlined to avoid the need for creating a new sheet every week.

Link to Loom

https://loom.com/share/69ba57f8696f42e4b563aa188c2f25dc?src=composer

[vdwintelligence]

Hi Cameron,

Thanks again for the Loom!

Think I found your solution.

The first module speaks for itself. However, within the second module, you can map the spreadsheet ID variable, but you need to change the setup of the module first. I will show you below how.

Let me know if this works for you!