Di dieu aya garis besar mungkin tina skrip Perl anu nyambung ka Google Spreadsheet API sareng scan ngaliwatan kolom munggaran lembar kerja: Masang modul Perl anu diperyogikeun pikeun berinteraksi sareng Google Spreadsheet API. Anjeun tiasa nganggo shell CPAN pikeun masang modul ieu: Ruby Copy Code $ cpan cpan> install Net:: Google:: Spreadsheet perl file skrip anyar sareng kalebet modul anu diperyogikeun: rust Copy code make strictly; Create Copy; make Copy API: Google:: Spreadsheet API: Set up the authentication credentials for accessing the Google Spreadsheet API. Anjeun kedah nyiptakeun proyék Google API console and enable the Google Spreadsheet API, then generate a service key to authenticate your data. The Jservice store provides a location and provide the necessary code in the worksheet. each copy code worksheet uses the first column of my worksheet = $$$$