Hey there,
I am currently kind of stuck with a zap. My goal is to save each day on a specific time certain rows from our database into a google sheet file. So far no problem at all, but as for the MySQL custom query I am kind of stuck. The query works just fine, though I only get one row at a time.
Is there a way to repeat the query as long as there are some rows not included in my google sheet for that specific date? Currently the query returns 68 rows.
Best
Max
P.S.: Here is my query:
SELECT CURRENT_DATE as Date, vb.title AS Marke, vm.title AS Modell, COUNT(*) As Anzahl
FROM vehicles As v
LEFT JOIN vehicle_brands AS vb ON vb.id = v.brand_id
LEFT JOIN vehicle_models AS vm ON vm.id = v.model_id
LEFT JOIN vehicle_statuses AS vs ON vs.id = v.status_id
WHERE v.status_id = 1
GROUP BY vb.title, vm.title;