Make.com is an amazing platform. It allows people like me, who have no expirience in programming to do amazing things, I would have never dreamt of doing myself. It has improoved my company’s processes a lot and has shifted workload from the staff.
I issue I can’t solve is related to the extraction of calendar appointments from a JSON file to a Google Spreadsheet. I can download the appointments in our online booking form as a JSON and I have tried to parse them and add them to a google spreadsheet as individual rows.
The JSON file has the following structure:
I am using an iterator module, not sure why exactly, but I saw it beeing used in similar scenarios.
So basically the calendar.output contains 7 collections, each containing the appointments for 1 day of the week. I want to add the date, hour, name, email and phone of the client to a Google spreadsheet, but I don’t see these values in the Google Spreadsheet Module. I have ran the scenario manually to make sure the values are visible.
What am not doing?