What is a google sheet and How can it help you?
As we can find on Wikipedia , the definition of Google sheet is that it’s a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google. Google Sheets is available as a web application, mobile app, and as a desktop application on Google's Chrome OS. The app is compatible with Microsoft Excel file formats.The app allows users to create and edit files online while collaborating with other users in real-time. Edits are tracked by users with a revision history presenting changes.
When it comes to YouCan’s store, we provide you with this a must have feature for Free , With its main options, Guideline to integrate it and a support to assist you in case of need.
Now let’s talk about how it can help you as a seller, Google sheet will allow you to track your order in real time, add any missing information, and organise your orders. Also You can communicate the sheet with your supplier in Drop Shipping cases, or with shippers in case you handle the shipping yourself.
How to integrate Google sheet in your store?
To integrate the Google sheet in your Store, First step will be to enable The App:
Click on “Get started” to be redirected to the following page.
In this Page you will have all the necessary and main steps to integrate the sheet.
Click on “Google Console for developers” to be redirected to the Google Console service.
First enter the project name.
Then click on “Create”.
Once the project is created, now we have to add the Google sheet API. in order to do that, follow the following steps :
Select the project you just created.
Click on APIs & Services.
Click on Library and search for “Google Sheets API”.
After enabling Google Sheets API, please follow the instructions below :
Afterwards, choose external as a user type :
That being done, the next step would be a form looking like this :
Enter the App Name : “YouCan”
Click on the dropdown list and choose the user support mail.
Add the link to your store's homepage.
Enter “youcan.shop” as an authorized domain.
Enter your developer’s email or paste the user support email.
Once you’re done with the form, click save and continue.
Click on “Add or remove scopes”
Select all the scopes.
Click on update.
Then tap Save and continue.
Click on “+ ADD USERS”
Enter the user support mail u typed earlier.
Tap on “ADD”.
Then click on “Save and Continue”.
Follow the steps above to create an OAuth client ID.
Choose Web application as an application type.
Enter the name you entered before.
Add the following link as an authorized redirect URLs :
https://seller-area.youcan.shop/admin/settings/integrations/google-app/connect/callback
Tap on Create.
Once the OAuth client ID is created, you will see this :
Click copy and paste both of the IDs here : https://seller-area.youcan.shop/admin/apps/googlesheet/settings
Paste in this case your Client ID.
Paste in this one your Client secret.
Tap on Connect account.
That being done, you will be redirected to a page looking like this :
Click on Allow, and there you go! Google Sheets must be connected successfully.
How to Create the Sheet ?
In order to have the Google sheet , You have to create one. The steps are easy and simple, First thing is to click on “Create New sheet” :
The second step the following:
Name Your sheet to be easy to fin.
This part is optional, you can create each sheet for each product, or one sheet for the whole Store.
Select the information you want to export to the sheet based on the checkout form information.
Save the changes .
The Last part is to activate the sheet so the orders Go directly to the sheet:
Congrats; You have successfully integrated, created and enabled the Google sheet feature.
This Tool will be your daily friend to check your orders and check the information submitted by customers in real time.
If you Found this article helpful, share it with your friends and partners and do not hesitate to contact us in case of need on : Support@youcan .shop
إرسال تعليق