Google Sheets Add-On
Budget: $30 – $250 USD
Your goal is to create a Google Sheets add-on based on my existing API so that users can connect my application to Google Sheets to send data from Google Sheets to my application and send data from my application to Google Sheets.
This application will replicate the existing concept I already use for my Zapier app so that users can skip using Zapier and can use Google Sheets and my app directly.
My API: JSON-RPC.
General Stories:
- As a user, I want to connect my Google Sheets account to my APPNAME account proving an Account ID and Account Secret
- As a user I want to create content in APPNAME whenever I add spreadsheet row to a specific sheet
As a user, I want to save data in Google Sheet (sheet) whenever new content is created in APPNAME.
::TRIGGER::
When a spreadsheet row is added, an API call should be executed on my side using my existing API.
The way I invasion this:
Users are guided through a simple process where they are requested to choose the sheet they want to use as a reference. Once a user selects this sheet, the user is requested to select the template that will be used for this project (this template will be loaded from my API, using a method).
Once the user selects this template, the user is taken to the next step, where the user is requested to map fields using the same Zapier philosophy for mapping fields. I can provide an example if needed.
::ACTION::
When a chosen template creates new content, my application updates a selected sheet from a spreadsheet. Every row will be new content successfully created. Users can select what information to add to every column. For this, the users would need to map the fields, which will require creating test content so that the data is triggered.
My application provides webhook fields. Ideally, users don't need to add a webhook. This application connects with the API and uses a webhook behind the scene.
::GENERAL::
- You would need to document the addon's code so that any developer can update the app in the future.
- Clean, light code following Google Addon's standard and policy
- You would need to provide the UI following GS' standard guidelines (make sure to take a look at it)
- In total, I believe you'll need to use three API methods from my existing API.
- I'll provide the API documentation and relevant example links when you request them so that you can evaluate the project.
- Only apply if you have experience building addons for Google Sheets or similar Google apps.
- I need your assistance with publishing the addon according to Google's standard.
- The code should be well structured so that it is also easy to updated and extend the functionality in the future.
This application will replicate the existing concept I already use for my Zapier app so that users can skip using Zapier and can use Google Sheets and my app directly.
My API: JSON-RPC.
General Stories:
- As a user, I want to connect my Google Sheets account to my APPNAME account proving an Account ID and Account Secret
- As a user I want to create content in APPNAME whenever I add spreadsheet row to a specific sheet
As a user, I want to save data in Google Sheet (sheet) whenever new content is created in APPNAME.
::TRIGGER::
When a spreadsheet row is added, an API call should be executed on my side using my existing API.
The way I invasion this:
Users are guided through a simple process where they are requested to choose the sheet they want to use as a reference. Once a user selects this sheet, the user is requested to select the template that will be used for this project (this template will be loaded from my API, using a method).
Once the user selects this template, the user is taken to the next step, where the user is requested to map fields using the same Zapier philosophy for mapping fields. I can provide an example if needed.
::ACTION::
When a chosen template creates new content, my application updates a selected sheet from a spreadsheet. Every row will be new content successfully created. Users can select what information to add to every column. For this, the users would need to map the fields, which will require creating test content so that the data is triggered.
My application provides webhook fields. Ideally, users don't need to add a webhook. This application connects with the API and uses a webhook behind the scene.
::GENERAL::
- You would need to document the addon's code so that any developer can update the app in the future.
- Clean, light code following Google Addon's standard and policy
- You would need to provide the UI following GS' standard guidelines (make sure to take a look at it)
- In total, I believe you'll need to use three API methods from my existing API.
- I'll provide the API documentation and relevant example links when you request them so that you can evaluate the project.
- Only apply if you have experience building addons for Google Sheets or similar Google apps.
- I need your assistance with publishing the addon according to Google's standard.
- The code should be well structured so that it is also easy to updated and extend the functionality in the future.