Can you share the screenshot of the Magic ETL & the data from both datasets?

Sorry for the late reply. Go to https://admin.google.com/u/5/ac/owl/list?tab=configuredApps click on the highlighted text "Configured for 1 org" and I can see this, to be honest, I forgot to grant access I tried so many ways and I lost track of the steps :(

I tried the steps below and managed to get it working. Login to your Google admin account https://admin.google.com/u/5/ac/owl/list?tab=apps Hover on the row Domo and you will see the "Change access" will appear. Click on Change access. In the next screen , select the all users option Choose Trusted and click Next Review…