Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Prerequisite

  • A file token.pickle which stores the credential information of Google API.(Refer Google Token Plugin)

Google Spreadsheet ID and Sheet Id.

  • The spreadsheet id and sheet id both can be found from URL.


1. Return Value (CSV) headers

 Below 4 operations return CSV as Return Value.

 (warning) Note : the headers are used as “variable name” when you extract data from CSV and they are case sensitive.


Operations                       Column A               Column B                    Column C

Add a Sheet:                     sheetId                  spreadsheetId

Delete a Sheet                  sheetId                 spreadsheetId

Rename a Sheet               sheetId                 spreadsheetId

Duplicate a Sheet            new sheetId        old sheetId                 spreadsheetId


 

2. Plugin operations and required parameters

 



 

 


Operations                       Column A       Column B                    Column C

Add a Sheet:                    sheetId spreadsheetId

Delete a Sheet                 sheetId spreadsheetId

Rename a Sheet               sheetId spreadsheetId

Duplicate a Sheet                        new sheetId     old sheetId                  spreadsheetId

 


  • No labels