A Real-Time Sync Between Excel & Google sheet

[vishu]

Hello Friends,

is it possible to real-time Sync between Excel & Google sheets without using any app or 3rd party addins or plugins?

Connected to Excel from Google Sheets. Google Sheets refreshes every minute but it doesn't reflect in Excel. Even RefreshAll is also not giving proper results.

Sub Refresh()
      ActiveWorkbook.RefreshAll
End Sub

The same question has been asked on other forums too but no luck.
A Real-Time Sync Between Excel & Google sheet

Thanks in advance

 

[vishu]

The above code was found from another thread and this might work but don't know how to use
Auto Transfer data from Google sheets to Excel at a set time interval. Help Please.

Sub ImportGoogleSheetsQuery()

Dim qt As QueryTable, url As String, key As String, gid As String

Dim n As Long
n = 0

Do Until n = 1

    If ActiveSheet.QueryTables.Count > 0 Then ActiveSheet.QueryTables(1).Delete
    ActiveSheet.Cells.Clear

 '***** Shared Google Sheets Link *****
    key = "XXXXXXXXXXXXXXXXXXXXXXX"
    gid = "0"
    url = "https://spreadsheets.google.com/tq?tqx=out:html&key=" & key _
    & "&gid=" & gid

    Set qt = ActiveSheet.QueryTables.Add(Connection:="URL;" & url, _
    Destination:=Range("A1"))

    With qt
    .WebSelectionType = xlAllTables
    .Refresh

End With

Application.Wait DateAdd("s", 20, Now)

Loop

End Sub

And this is my google sheet url

Google Sheets: Sign-in

Please help me out guys