Automatic time trigger script Google sheets

I have designed a project in epicollect5 which is continually receiving an entry from collectors. Thus I have connected it with a Google sheet by a script and I can see the analysis part by the pivot table . However it needs refreshment manually by clicking the " Get a Survey Data" button every time.
My question is how can I get an automatic time trigger script or instruction without manually refreshing every time when I open the sheet?

hola, esto se puede solucionar importando la informacion en tiempo real a google shets, se hace usando la API, si requiere ayuda personalizada y de manera particular le puedo mostrar los avances que he tenido, y ofrecerle una asistencia personalizada. +573172947925 wsp.

Triggers in Google Sheets.