Moving data from Pipedrive to Google Sheets

[Aneta_Wozniak]

Hey!

I’ve created a scenario, but it is not working as I want it to. The general idea is to move won deals from a specific filter in Pipedrive to Google Sheets with as few operations and as little data usage as possible. Basically, everything is working except for one thing: the custom fields that I have in the CRM. When I map them, I get them back as option IDs. My goal is to get them back as option labels, so the text value, not the IDs. Here is my scenario:

1. Initialize Variables: Sets initial variables next_start to 0 and data_results to an empty array.
2. Loop Setup: Repeats the following process 7 times.
3. Retrieve Variables: Gets current values of finished, next_start, and data_results
4. Fetch Data: Makes an API call to Pipedrive to get deals data, using next_start to paginate.
5. Update Variables: Merges new data with existing data_results and updates next_start.
6. Clear Google Sheets Range: Clears a specific range in Google Sheets if no more items to fetch.
7. Append Data to Google Sheets: Adds fetched deals data to Google Sheets.
8. Mark as Finished: Sets finished variable to true to signal the end of the process.

I was thinking that I could use the batch append rows step for some kind of mapping to switch the option IDs to text values, or just add something like an API key_label or API key_name, but it does not work.

How should I approach it? I want to achieve this with as few steps as possible and using the least amount of operations and data usage.

I will be really grateful for all the help!