BUILD A GOOGLE SHEET

I have a very simple Excel document that works well, however the Macros do not convert to a Google sheet. We want to access the spreadsheet via Google Drive therefore I require a Google sheet to be created that functions as required. I need to copy data from one sheet to another based on criteria. The macro that works on Excel is posted below for reference. I can not find the proper coding for Google sheets and require assistance. Thanks in advance for your help!

Sub Test()

Application.ScreenUpdating = False

Sheet2.UsedRange.Offset(1).Clear

With Sheet1.Range("A2", Sheet1.Range("H" & Sheet1.Rows.Count).End(xlUp))
.AutoFilter 8, "Sold"
Union(.Columns("A"), .Columns("B"), .Columns("C"), .Columns("D")).Offset(1).Copy Sheet2.Range("A" & Rows.Count).End(3)(2)
.AutoFilter
End With

Application.ScreenUpdating = True

End Sub