Script Developer/ Google Sheet Automation Development

We are looking for who can build a script that can extract information from a Google Sheet and send it to a customer service agent. It suggests identifying the columns in the sheet that contain the relevant information and using a library such as the Google Sheets API to read the data and store it in variables. The message also outlines the steps involved in building the script, including authentication and connection to the Shopify or Google Sheets API, querying the API to extract data, formatting the data, and sending it to the desired destination.
The message provides an example of the information that may be needed to assist a customer with an order-related issue, including order number, customer name, shipping address, phone number, email address, order date, order total, payment method, shipping method, shipping carrier, tracking number, item description, item price, and item quantity. The message emphasizes the importance of providing all necessary details to enable the customer service agent to provide timely and accurate support.

Job Title: Script Developer
Job Description:
We are seeking a skilled Script Developer to join our team and assist in building a script that can extract information from a Google Sheet and send it to a customer service agent. The successful candidate will be responsible for identifying the columns in the sheet that contain the relevant information and using a library such as the Google Sheets API to read the data and store it in variables.
Responsibilities:
Authenticate and connect to the Shopify or Google Sheets API using API keys and authentication details.
Query the API to extract the relevant data from your Shopify store or Google Sheet.
Format the data to fit your desired output format.
Send the formatted data to your desired destination, such as an email or a chat interface.
Collaborate with cross-functional teams to understand customer needs and requirements.
Troubleshoot and debug any issues that arise during the development process.
Maintain code quality and documentation.
Requirements:
Strong programming skills, particularly in Python or other scripting languages.
Knowledge of API development and integration.
Familiarity with Google Sheets API, Shopify API or other similar tools.
Experience working with databases and data structures.
Good problem-solving and communication skills.
Ability to work independently and as part of a team.
Attention to detail and ability to work efficiently under tight deadlines.
Bachelor’s degree in Computer Science or related field.
If you are a driven and skilled Script Developer with a passion for building high-quality software solutions, we encourage you to apply for this position. We offer a competitive salary, benefits package, and opportunities for professional growth and development within our organization.