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.
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;
Best answer by DanversView original