Choosing Google Sheet name within an output module

[David_salch]

I am new, trying to test a scenerio but cant find how to make this happen:

Goal: when a payment is made in xero, append a row to the proper google sheet with payment info for user

Challenge: within the google sheet, there is one customer per sheet, so I need a way to choose the proper sheet name based on the account name from within xero. There are a small number of accounts, hence why one sheet per customer in google sheets.

One idea was to use a filter and multiple google sheet output modules, one per client. That is actually workable, but means that I would need to modify the scenerio every time a client is added (and a new sheet created). Is there a more automated way to do this?

[samliew]

Welcome to the Make community!

You can use the Google Sheets “List Sheets” module to get all the sheets within the Spreadsheet document.

This way, you can filter out only the sheet matching the customer’s name

Give it a go and let us know if you have any issues!

If you want to learn more about Make, you can read up in the Help Center. I also recommend doing the tutorials in the Make Academy, and learn advanced skills like how to make custom apps to any API in the Make Partner Training Portal - both have certificates for successful completion.