Usercript to fill in a form from spreadsheet | Technology | TO…
Usercript to fill in a form from spreadsheet
  • C2C aRBa [328496]aRBa [328496]
    • aRBa [328496]
    • Role: Civilian
    • Level: 17
    • Posts: 366
    • Karma: 0
    • Last Action: 4 hours
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Thread created on 22:01:28 - 26/05/21 (5 months ago)
    |
    Last replied 18:39:54 - 01/06/21 (4 months ago)
    Hello guys. I am very new with coding.

    I have a form from a website to fill in with data from google spreadsheet. The form is not a google form. Basically the script will fill in the form with data from the first row in the spreadsheet, submit the form, then fill up data from the next row, submit and so on.

    I have searched on using userscript like Greasemonkey to do this, but so far there is no tutorial on how to import the data from a spreadsheet.

    Thank you in advance
  •   Bhappychap [2270497]Bhappychap [2270497]
    • Bhappychap [2270497]
    • Role: Civilian
    • Level: 41
    • Posts: 4276
    • Karma: 3089
    • Last Action: 36 minutes
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 18:39:54 - 01/06/21 (4 months ago)
    Post link copied to clipboard Copy post link
    You can fetch the google sheet data via API: 

    https://developers.google.com/gdata/samples/spreadsheet_sample

    Then its trivial to load it how you need in many website html form.
Reply
Thread Title: