Project overview
The project automated the retrieval of new orders from The Art of Books platform using their API, filtered them by current year and non-duplication, and added them to a Google Sheet titled "AOB orders."
The integration was built using Integromat, with a scheduled HTTP request triggering the flow.
The scenario includes filters to ensure only current orders are processed, searches the sheet to prevent duplicates, and inserts new rows accordingly.
Communication was great!
I received exactly what I needed. Very helpful.
- kmulhol
Key features delivered
- HTTP module to fetch orders using an encoded filter (`paid_ship_now`)
- Looping through each order
- Filtering orders by the current year
- Searching existing Google Sheet rows
- Adding new rows if not already present
- Scenario documentation and scheduling options
- Manual run and debugging support
Screenshots
Integromat scenario showing the full order flow: HTTP request → Filter each order → Check if current year → Search Google Sheet → Add if not exists.
Technology stack
Make.com
Google Sheets
HTTP Module
Art of Books API