Collect app's data getting submitted to google sheet but not into odk aggregate installed on tomcat server

when I submit the form in collect app with google sheet in my google drive as storage, my form is getting submitted. But when I submit the form with odk aggregate installed on tomcat server (local) as backend, **my **form is not getting submitted. I get Error: Connection Timeout . Please suggest any solution

Closing in favor of Connecting collect app and odk aggregate. Please do not create multiple topics with the same issue.