C:\Temp\
back to:C:\Users\xxxxx\Google Drive\Accounts\
as you had it in your original post, I'll wager that even the code you accepted will fail.
DoCmd.TransferSpreadsheet acExport, 10, "Analysis-Cost", "C:\Users\xxxxx\Google Drive\Accounts\Analysis.xlsx", True, "Sheet1"
Which does refer to "\Google Drive\".
Try below:
Open in new window
This will make spreadsheet file in C:\Users\xxxxx\Google Drive\Accounts\Analysis.xlSource is from here