Google Suite administrator might need to activate access to Google spreadsheets add-ons for the users. Read more
To be able to use Akeneo PIM for Sheets add-on first of all we need to generate OAuth cliend id and secret on Akeneo PIM side.
To do this, go to the System menu of your PIM and select the API connections entry.
From here, you can click on the Create button. Give a name to the connection you are about to create and confirrm. The PIM will then automatically create credentials for you, that you will find in the API connections grid.
More information about Akeneo PIM API connections management can be found here.
After you created API connection on Akeneo PIM side you can start to use Akeneo PIM to Sheets add-on.
Currently next entities can be imported to Google Sheets:
All entities are imported in the format which is compatible with Akeneo PIM structure.
After you import Akeneo PIM data to Google Sheets, edit them, you can export them to CSV file(s) and import to Akeneo PIM back.
Currently Products and Product Models data is limited (attributes values are not included). We plan to add this in the future.
Analyze your Akeneo PIM data with Explore in Google Sheets.
When you have easier access to data—and can figure out what it means quickly—you can solve problems for your business faster.
You might use Explore in Sheets to analyze different aspects of your data. Explore in Sheets can help you track down this information, and more importantly, visualize it.
Getting started is easy. Just click the “Explore” button on the bottom right corner of your screen in Sheets. Type in a question about your data in the search box and Explore responds to your query.