Technical assignment (TA) for the development of API integration between Instagram + Google Apps Script for Google Sheets.
Goal:
Create an integration that automatically transfers information from Instagram to Google Sheets, including user and message data. This will allow for centralized storage and tracking of communication with clients.
Main tasks
1. Develop a script based on Google Apps Script that will interact with the Instagram API and transfer data to Google Sheets.
2. Set up the transfer of information to the Google Sheets table, with the possibility of real-time updates or at specified intervals.
Data requirements
The following data must be transferred to Google Sheets:
1. Request number: Unique identifier for each request (message).
2. Profile photo: Link to the user's profile image.
3. Username: Name of the account on Instagram.
4. User nickname: User's login (username).
5. Profile link: Full link to the user's profile on Instagram.
6. Profile description: Description provided in the user's profile (bio).
7. Message date and time: Time of sending or receiving the message.
8. Message content: Text of the message, as well as links to media files (photos, videos), if present.
9. Outgoing message: Response from the manager, including links to attached files, with the date and time of sending.
10. Message type: Indication of whether the message is incoming or outgoing.
11. Message status: Read or unread.
Functional requirements
1. Connection to the Instagram API: Implement a connection to the Instagram API to obtain necessary data about messages and profiles.
2. Authorization: Set up secure authorization via OAuth 2.0 to ensure access to Instagram data.
3. Data transfer to Google Sheets: Develop Google Apps Script for automatic transfer of received information to the Google Sheets table with corresponding columns.
4. Data updates: Ensure automatic updating of information upon receipt of new messages on Instagram.
5. Error handling: Set up error handling for possible issues when retrieving data from the API and writing to the table (e.g., network failures or lack of access to data).
Expected result
The integration will allow for the automatic transfer of all necessary data from Instagram to Google Sheets, improving the management process of client messages and simplifying the tracking of sales funnel stages.
Additional requirements (optional)
• Ability to add tags for managing client statuses.
• Setting up notifications in case of errors when working with the API.
Freelancehunt 
