convert vba macro to google sheets : i need a way to translate a vba excel macro to google sheets, the code below transfers a list of data to an invoice and then saves it as a pdf i searched online for a translator but didn't find it if some one knows one or if some one can translate this one.

thank you in advance  





    Private Sub CommandButton1_Click()
    
    'define value
    Dim customer As String
    Dim invoicenumber As Long
    Dim invoicedate As Long
    Dim path As String
    Dim myfilename As String
    Dim rate As Long
    Dim r As Long
    
    'define our last row
    lastrow = Sheets("Dispatch1").Range("O" & Rows.Count).End(xlUp).Row
    
    ' start at row 5
    r = 5
    For r = 5 To 10
    If Cells(r, 1).Value = "done" Then GoTo nextrow
    invoicedate = Sheets("Dispatch1").Cells(r, 5).Value
    rate = Sheets("Dispatch1").Cells(r, 15).Value
    invoicenumber = Sheets("Dispatch1").Cells(r, 17).Value
    Amount = Sheets("Dispatch1").Cells(r, 19).Value
    Application.DisplayAlerts = False
    Sheets("invoiceblank").Select
    
    ' map the variables to invoice worksheet data
    ActiveSheet.Range("F4").Value = invoicedate
    ActiveSheet.Range("G4").Value = invoicenumber
    ActiveSheet.Range("F18").Value = rate
    path = "C:\Users\Dell\Desktop\feb" 
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
            fileName:="C:\Users\Dell\Desktop\aa new trucking\feb\" & _
           ActiveSheet.Range("G4 ").Value & _
           Worksheets("Customers").Range("A1").Value & _
            ActiveSheet.Range("A16").Value & ".pdf", _
            OpenAfterPublish:=False
    
    'our label next row. Labels have a colon after their name
    
    nextrow:
    
    Next r
    
    End Sub