www.emails-to-sheets.com
Business,

Extracting Data From Emails

Many businesses receive email customer queries and need to extract data in order to categorize and prioritise these queries. This can help streamline the process to increase efficiency.

Email parsers such as www.emails-to-sheets.com can be used to do this. The parser will immediately extract the relevant information from the emails that are forwarded.

Automated Process

Emails are a great source of information for your business. However, they can also be a burden. Inboxes can be cluttered with emails from customers, shipment tracking notifications, or sales leads. This can distract from important work. In the past, it was a manual process to sort and extract data from emails. Email extraction tools are available to automate the time-consuming task.

www.emails-to-sheets.com

By using an automated email parser, you can eliminate the need to manually sort and categorize information. This tool can scan and extract key data such as contact information, order status or invoices from incoming emails. The data can be saved into a database or spreadsheet. The process can be customized to include rules or filters that prioritize and organize incoming emails based on specific criteria. It can be set up to process emails in batch, reducing the time it takes to extract text.

An email automation tool can automatically extract data from incoming emails and convert it into a file format such as TXT, JSON or CSV. It can also extract images, signatures and attachments, and utilize OCR to read text from documents attached to emails. The data can be downloaded and synchronized to your ERP, accounting software, or CRM in order to streamline processes and increase productivity.

Parseur, a third party email parsing tool, is another option. This cloud-based solution uses AI to make the process of extracting text from emails quicker and easier. It can also prioritize emails based on their nature, filtering them and ensuring that a customer service representative responds to them promptly.

You can also write a script to extract the text from an email. This requires advanced programming skills, but allows you tailor the process to meet your specific needs. It can be used to parse HTML emails, for example, by using regular expressions or a web scraping library such as BeautifulSoup-python. Once the code is written, it can be tested and refined to ensure that it is working properly.

Rule-Based Filtering

Email extraction is an important process that allows businesses retrieve important information. This data can be used to streamline workflows, boost productivity and get contact information from customers. It can also improve the management of data and enhance decision making.

In the past, extracting data from email was a manual process, which required human intervention and led to inconsistencies. This process can be made easier and more efficient with the help of automated software and tools. There are several ways to automate the process of extracting data from emails, including using rules and filters. These can be created manually or automatically. The benefit of this method is that it can be customized to fit the needs of specific business processes.

The first step in the process of extracting data from emails is to identify what types of emails you need to parse. Create a filter on your email client and select only the emails that you want to process. Once the emails are selected, the next thing to do is create a filter that will extract the data from the selected emails. The data can be exported to other systems or sent. If you receive many invoices by email, for example, you can set up a rule to extract the details and enter them into your accounting software.

Excel is another way to manually extract the data from emails. This can be a tedious and error-prone task, especially if you have a large number of emails. To avoid errors, you should ensure that your spreadsheet program is regularly updated.

Alternatively, you can use an online automation tool such as Power Automate to create an automatic process for extracting text from emails. This tool provides a user-friendly interface that makes it easy for individuals with no coding experience to create automated workflows. To begin, create a flow which triggers when a new message is received. Then set up an action to receive and filter the message. Then add a parse JSON action to extract the required text from the email. Add a file action to save extracted text to a specific location.

Manual Process

Emails are an essential part of most businesses. Whether it is customer queries, software companies selling their B2B or SaaS services or any other type of notification, emails are sent out constantly. These emails can pile up in an inbox and sometimes contain important information that is overlooked. To ensure that important information is not missed, it is crucial to process email data and extract relevant data. However, manual processing of emails can be time-consuming and error-prone. Email parsing tools can automate this task, ensuring that important information is extracted and processed.

A great way to streamline business processes is by using an email parser. These email processors are able to take in incoming messages and extract data using keywords. These data can be saved to a spreadsheet or database. This saves time and effort, while also providing accurate and consistent data.

An example of how to use an email parser is to send invoices. The email parser will search for specific details in an invoice, such as invoice date and order numbers. The email will be automatically saved to a sheet with the invoice date and number attached. This is an easy and efficient way to keep track of all incoming invoices.

A parser for emails can also be used in order to respond to queries from customers. These queries are often sent via email, and they need to be prioritized quickly. The email parser scans the incoming query to extract key information like the customer’s contact information, interest area, and name. This information can then be automatically transferred into the company’s CRM or ticketing system, allowing the sales team to follow up with the potential lead.

A good email parser will be able to handle different data formats, ensuring the correct information is returned. The tool, for instance, should be able not only to extract data out of HTML, DOCX or PDF files, but also from a JSON reply. The software should be able to convert the data into different formats in order to make it easier to integrate and use.

Programming Script

Email data extraction can be a valuable process that saves businesses time and money by streamlining processes and eliminating human errors. It can also help analyze trends and gain insight into consumer behavior. Email extraction can be performed manually or automated using tools and software programs. Manually, you open each email and copy the desired information. Then, you paste it into a spreadsheet. This method can be time-consuming and error-prone, and it is not scalable to large volumes of emails.

Use an email parser to identify and extract specific data from incoming emails. This tool can be configured to recognize specific words and patterns in a given email, allowing you to automatically pipe structured data into the correct location. Email parsing software is available from third-party vendors and can be tailored to your specific needs.

A company that receives lots of inquiries from customers can use a parser for email to send the contact information automatically into a CRM database. This allows sales representatives to focus on closing more deals rather than on transferring the information from one app to another.

Creating an automated workflow that extracts text from a email using Power Automate is easy. Start by creating a flow with the compose as your trigger. Add a parse JSON to the workflow. Create a file action to save the extracted texts in a specific location and folder. Finalize the flow by testing it with different types emails and making any necessary adjustments.

A person standing in a room
Business,

A one-stop shop for LafargeHolcim products in Latin America

Just over a decade since its launch in Ecuador, our retail construction franchise network, Disensa, has built a network of 1,000 stores that spans the Latin America region. Disensa offers easy access to LafargeHolcim products and solutions to self-builders and small-scale contractors.

Disensa, our one-stop-shop

In 2005 we established a retail construction franchise network, called Disensa, in Ecuador. The network laid the foundation for a worldwide expansion that now accounts for 1,000 Disensa stores across Latin America (including Mexico) and more than 600 similar stores in the Middle East and Africa, where they are called Binastore.

Our vision for retail is to offer self-builders and smaller contractors a one-stop shop. Within our stores these customers enjoy easy access to LafargeHolcim’s own building solutions as well as a wide range of other construction materials and services.

The stores support customers with microcredit and technical help as well as complete kits for different phases of home building. They also offer solutions to facilitate construction including financing plans, access to architects and standard building designs.

Laying the foundations of success

To strengthen the foundation we give our franchisees the tools to succeed, for example with training on products, store management, marketing and finance.

With individual customers accounting for around 60% of Group net sales, having direct access to the retail market is a strategic priority. In 2018 we aim to continue broadening our reach, focusing particularly on India and Southeast Asia. This global initiative demonstrates how we are bringing our commitment to commercial excellence to life for our retail customers while developing a strong network of trained franchisees.

A person sitting at a table
Construction,

Industry 4.0 for cement production: LafargeHolcim launches the “Plants of Tomorrow”

LafargeHolcim upgrades its production fleet for the future. Targeting a global network of over 270 integrated cement plants and grinding stations across more than 50 countries the company will be utilizing Automation Technologies and Robotics, Artificial Intelligence, Predictive Maintenance and Digital Twin Technologies for its entire production process. This four year program makes the “Plants of Tomorrow” Initiative one of the largest roll-outs of Industry 4.0 technologies in the building materials industry.

A “Plants of Tomorrow” certified operation will show 15 to 20 percent of operational efficiency gains compared to a conventional cement plant. LafargeHolcim is presently working on more than 30 pilot projects covering all regions, where the company is active. The company’s Siggenthal, Switzerland, integrated cement plant will be the lighthouse where the integration of all relevant modules will be tested for the global “Plants of Tomorrow” initiative.

Solomon Baumgartner Aviles, Global Head Cement Manufacturing: “Transforming the way we produce cement is one of the focus areas of our digitalization strategy and the ‘Plants of Tomorrow’ initiative will turn Industry 4.0 into reality at our plants. These innovative solutions make cement production safer, more efficient and environmentally fit. We are moving to fully data-driven operations in order to support further profitable growth as part of our Strategy 2022 – ‘Building for Growth’.”

Among the technologies implemented are predictive operations that can detect abnormal conditions and process anomalies in real-time. This will reduce maintenance costs by more than 10 percent and significantly lower energy costs. Digital twins of plants are created to optimize training opportunities.

Automation and robotics is another important element of the strategy. Unmanned surveillance is being performed for high exposure  jobs in the entire plant. Partnering with Swiss start-up Flyability, the company is using drones that allow the frequency of inspections to increase while simultaneously reducing cost and increasing safety for employees by inspecting confined spaces. The concept is now being rolled out to several markets including Switzerland, France, Germany, United Kingdom, United States, Canada, India and Russia.

In addition, the new PACT (Performance and Collaboration) digital tool allows operational decision making from experience based to data-centric by combining data from various sources and enabling machine learning applications.

Open innovation at the heart of the “Plants of Tomorrow”

LafargeHolcim is the leading global building materials and solutions company serving masons, builders, architects and engineers all over the world. Group operations produce cement, aggregates and ready-mix concrete which are used in building projects ranging from affordable housing and small, local projects to the biggest, most technically and architecturally challenging infrastructure projects. As urbanization increasingly impacts people and the planet, the Group provides innovative products and building solutions with a clear commitment to social and environmental sustainability. With leading positions in all regions, LafargeHolcim employs approximately 80,000 employees in around 80 countries and has a portfolio that is equally balanced between developing and mature markets.

LH MAQER, the company’s new platform to identify the most impactful technologies and target start-up technology companies also aims at establishing new partnership models with both manufacturing and software companies.

Philipp Leutiger, Chief Digital Officer: “Our global manufacturing expertise in cement is second to none. Now, with our LH MAQER platform, we open up our operating model to the creativity and ingenuity of some of the world’s most gifted and talented digital minds. We are already seeing the success of this approach in many of our operations globally.”

Improving performance through network of data-driven control room technologies

LafargeHolcim has already launched technology to track performance centrally and allocated resources to support the plant network in real time. More than 80 percent of LafargeHolcim’s cement plants are already connected to its Technical Information System that provides data transparency at plant, country, regional and global level. Some country operations have more than a decade of historic technical data available. Other systems allow the remote control of certain parts of the operations through online condition monitoring systems. Since its implementation in 2006, this system alone allowed for CHF 80 million in savings and an additional 3 million tonnes of cement sold through less breakdowns.

Watch a video on the “Plants of Tomorrow” here.

About LafargeHolcim

LafargeHolcim is the global leader in building materials and solutions. We are active in four business segments: Cement, Aggregates, Ready-Mix Concrete and Solutions & Products.
With leading positions in all regions of the world and a balanced portfolio between developing and mature markets, LafargeHolcim offers a broad range of high-quality building materials and solutions. LafargeHolcim experts solve the challenges that customers face around the world, whether they are building individual homes or major infrastructure projects. Demand for LafargeHolcim materials and solutions is driven by global population growth, urbanization, improved living standards and sustainable construction. Around 75,000 people work for the company in around 80 countries.

Follow us on Twitter @LafargeHolcim

About LH MAQER

LH MAQER is the global innovation platform driving change through open innovation in the building materials sector. It focusses on connecting technology companies to actual use cases in the entire LafargeHolcim footprint, from quarry to construction site.
Inspired by open innovation movements in software development, LH MAQER opens up the entire footprint of LafargeHolcim step by step to new formats of innovation. This includes quarries, manufacturing sites, logistics networks, and sales organizations, as well as the many relationships LafargeHolcim has throughout the value chain, from waste co-processing to construction sites. We are convinced that sustainable and efficient manufacturing and construction will only be achievable by leveraging new ways of working and innovation.

A group of people standing on top of a wooden fence
Business,

LafargeHolcim to acquire one of the leading Romanian precast producers

LafargeHolcim has signed an agreement with ORESA for the acquisition of Somaco, one of Romania’s leading precast concrete producers. The transaction will allow LafargeHolcim to develop its position on the Romanian building materials market, where the company is already present in the cement, ready-mix concrete and aggregates segments.

Jan Jenisch, CEO of LafargeHolcim: “This is our sixth bolt-on acquisition this year and we are delivering on our commitment to further develop our Solutions & Products business segment as part of Strategy 2022 – ‘Building for Growth’. The acquisition enables LafargeHolcim to enter Romania’s fast growing precast concrete market and to become an integrated solutions provider for our local customers.”

Somaco has leading positions and operates five precast concrete plants and one plant for aerated blocks in Romania. The company reported net sales of EUR 56 million in 2018 and has 750 employees. It has a strong portfolio of precast solutions for bridges, tunnels, subways and logistics platforms and supplies products for the residential sector. Romania’s precast segment is expected to grow over the coming years thanks to the country’s high construction and infrastructure needs.

The transaction is subject to regulatory approvals and is expected to close in Q4 2019.

About LafargeHolcim

LafargeHolcim is the global leader in building materials and solutions. We are active in four business segments: Cement, Aggregates, Ready-Mix Concrete and Solutions & Products.

With leading positions in all regions of the world and a balanced portfolio between developing and mature markets, LafargeHolcim offers a broad range of high-quality building materials and solutions. LafargeHolcim experts solve the challenges that customers face around the world, whether they are building individual homes or major infrastructure projects. Demand for LafargeHolcim materials and solutions is driven by global population growth, urbanization, improved living standards and sustainable construction. Around 75,000 people work for the company in around 80 countries.

More information is available on www.lafargeholcim.com

Follow us on Twitter @LafargeHolcim

About ORESA

ORESA is family-owned equity investment company with Swedish roots, active in Romania since 1997.

ORESA’s investment strategy is to develop, together with strong entrepreneurs and management teams, market leading companies in favorite sectors such as business services, financial services, construction materials, FMCG or retail & distribution. Besides Somaco, the company’s current portfolio consists of four companies that are market leaders in their sectors: La Fantana, RTC, Romanian Business Consult and Kiwi Finance. ORESA has previously owned companies such as Fabryo-Atlas, Duraziv, Motoractive, Credisson, Flanco, Brewery Holding (Ciuc) and Medicover.

A man wearing a suit and tie
Business, Construction,

CEO Jan Jenisch on the future of building materials

The world is coming together this September for the UN Climate Action Summit and the NYC Climate week, to discuss ways to accelerate action to stop climate change. Building materials and infrastructure play an important role, so LafargeHolcim CEO Jan Jenisch shares his views.

Q: There’s going to be a lot of discussions this week about how industries across all sectors are working towards carbon neutrality – and with buildings responsible for nearly 40% of global emissions1, how is LafargeHolcim working to mitigate this?

Today climate change is a large challenge for society. Buildings and infrastructure are particularly important as they have a significant carbon footprint. Looking forward, it is estimated that 60% of the infrastructure that humanity will need by 2050 has not yet been built. That is why innovation in materials and construction is key. It will enable us to transition towards carbon-neutral and circular models. Concrete is the backbone of this transition. LafargeHolcim is leading the way by being at the forefront of innovation and by introducing more low-carbon products and solutions to our customers worldwide.

Q: What role will concrete play in the carbon-neutral cities of the future?

Concrete will play one of the most important roles in the transition towards carbon-neutral construction. No other material is more safe, versatile, resilient and widely available than concrete. And this is fundamental as the world population is growing, and cities are becoming bigger and more complex. We need smart solutions to tackle these challenges, and we need them at scale. Concrete provides multiple responses to this challenge: it is locally produced, easily recycled, and has exceptional heating and cooling insulation properties. It is safe, non-flammable and can be poured in all desired shapes and forms, and is a material that stands the test of time. And most importantly, it has relatively low embodied energy and emissions compared to most other materials. This is why we advocate for looking at the life-cycle of a building regarding carbon footprint. With this perspective, concrete surpasses all other materials.

Q: Change is possible and beginning to happen, but many would argue this needs to happen more quickly. How will LafargeHolcim accelerate its efforts towards a more sustainable built environment?

LafargeHolcim cement is already among the most carbon-efficient in the world, and we will persevere in our endeavor across all of our regions. In Europe, where we operate 54 cement and grinding plants, we are investing CHF 160 million over the next four years to further reduce CO2 emissions by another 15% by 2022. We will achieve this mainly by reducing the amount of clinker (the most CO2 intensive component of cement) in our products and by using more alternative, non-fossil fuels to heat our cement kilns. In the first six months of 2019, we increased the use of alternative energy such as non-recyclable municipal waste and biomass waste to replace fossil fuels by over 10%.

We are the only building materials company with a central research organization. More than 50% of our current R&D focus is on sustainable solutions, especially on CO2 reduction. Our vision for 2050 is that the built environment will be carbon neutral, and fully recyclable with a positive environmental impact. We will contribute to the realization of this vision by focusing on four pillars: Climate, Circular Economy, Environment and Communities. For each of these four pillars, we have identified the most material aspect and have set targets for 2022 and 2030.

A living room filled with furniture and a large window
Construction,

Material choices

The sweltering-hot Paris summer this year confirmed yet again to Rodrigue Leclech that the world needs to move fast if it wants to beat climate change. Rodrigue specializes in energy efficiency in buildings. “We didn’t expect temperatures to reach 40 degrees Celsius in the summer before the year 2030 but in fact it’s already happening now.”

Rodrigue helped LafargeHolcim France develop a digital carbon configurator called Lafarge 360 Design, enabling design offices to calculate the projected CO2 impact of the foundation and superstructure of new residential buildings. Out of a total of fourteen structural elements of new builds, these are the two that have the highest carbon impact. The calculations take into account local specifications, norms and building regulations. The tool gives a first estimate but does not yet replace a more in-depth study of the design that also includes the thermal envelope or energy use. It is however becoming ever more accurate as new projects are continuously being entered into the tool, with now currently around eighty projects delivering data.

“360 Design comes at a crucial time as the focus is increasingly shifting to the construction industry,” he says. France has committed itself to achieving carbon neutrality by 2050 and is facing the massive challenge of renovating the currently existing building stock and decarbonizing the construction industry as a whole. The construction industry accounts for 45% of the country’s energy needs and over a fourth of its greenhouse gas emissions. The country introduced thermal energy regulations on buildings (Régulations Thermique, RT) in 2012. The fifth since 1979, and is bracing for new, tougher regulations in 2020 that will require new homes to have an improved carbon footprint across their full lifecycle. To help ease the transition, France introduced a voluntary certification scheme in 2016 called “E + C-” to reflect the environmental performance of new builds. It rates both energy consumption (E) and the carbon impact across its lifecycle which encompasses the construction phase, an operational phase of around 50 years, plus the end of life phase.

The scheme will become law in 2020 and is expected to have an important impact on the use of concrete. “Concrete has firmly established itself in the last 60 years as a traditional building material in France but our understanding of its carbon impact is still not well understood,“ explains Rodrigue. “This is where the tool will make a difference as it gives an indication of the carbon footprint of the concrete selected, and can influence the choice of materials used for the building.”

Rodrigue expects to see a greater mix of building materials in the construction industry in the future, combining concrete with wood and others. But it’s clear that concrete is here to stay: “Concrete has amazing properties that make it an ideal building material so for sure people will continue to build with it. But it’s vital that we improve its carbon footprint, and that’s why we will continue to work closely with the building materials sector to help achieve this.”

Photo below: Rodrigue Leclech – consultant in energy efficiency, with Paris based consultancy Pouget

A group of people in uniform
Real Estate,

LafargeHolcim expands affordable housing solutions in Africa

LafargeHolcim is increasing its commitment to provide low-carbon and affordable housing solutions in Africa by adding further production capacity for its Durabric soil-stabilized bricks. As part of its 14Trees joint venture with CDC, the UK’s development finance institution, the new plant located in Malawi will industrialize LafargeHolcim’s Durabric solution, the first soil-stabilized brick that is sold on mass scale in sub-saharan Africa. 14Trees is now also being introduced in other African markets including Kenya and the Ivory Coast.

Miljan Gutovic, Region Head Middle East Africa: “Today, less than 10 percent of the population in Africa can afford the cheapest newly built house. LafargeHolcim, with its unique innovation capabilities, has developed a range of construction solutions to make houses more affordable for the majority while improving the environmental footprint of those buildings. With additional production capacities, we are now able to offer these solutions beyond Malawi and increase our positive contribution further.”

Durabric is one good example of efforts to take sustainable solutions to scale. Since 2016 14Trees has worked with the construction sector in Malawi, one of the poorest countries in Africa, to make Durabric the technology of choice in the country. Within the first three years of operations, 2 million bricks have been sold saving over 4,000 trees and avoiding over 15,000 tons of CO2 emissions.

Sustainable and affordable housing solutions to prevent further deforestation

Burnt clay bricks, which remain the most used building material in Malawi and several other countries, involve heavy consumption of firewood due to the need to fire the clay that is used to make the bricks. Malawians burn around 850,000 tons of fuelwood per year in the process of firing bricks. At this rate the entire country would be deforested in a generation, so solutions such as Durabric provide viable alternatives.

Durabrics can save 14 trees for each simple house built compared to fired bricks, thanks to a production process that uses a mixture of soil, sand, cement and water without firing. They are three times stronger than traditional bricks, result in one-fifth of the CO2 emissions compared to common bricks, are up to 20 percent cheaper per square meter of wall and are more resistant to heavy rainfall.

Complementing the Lilongwe based factory, the new plant is located in Blantyre, the country’s business hub and second largest city. In addition, 14Trees has also launched two mobile plants that will be able to flexibly serve rural communities. Those mobile plants cut transport costs and at the same time provide employment for local villagers – often providing them with their first ever decent salary.

14Trees has also developed a turnkey house solution with Durabric as part of which it delivers a one-bedroom house in 12 weeks for less than USD 20,000 and offers home-owners a credit in collaboration with local banks.

About LafargeHolcim

LafargeHolcim is the global leader in building materials and solutions. We are active in four business segments: Cement, Aggregates, Ready-Mix Concrete and Solutions & Products.

With leading positions in all regions of the world and a balanced portfolio between developing and mature markets, LafargeHolcim offers a broad range of high-quality building materials and solutions. LafargeHolcim experts solve the challenges that customers face around the world, whether they are building individual homes or major infrastructure projects. Demand for LafargeHolcim materials and solutions is driven by global population growth, urbanization, improved living standards and sustainable construction. Around 75,000 people work for the company in around 80 countries.

A train traveling over a bridge
architecture,

CO2-reduction targets validated by Science Based Targets initiative (SBTi)

  • Industry leader in reducing CO2
  • Approval of direct emissions reduction target and new ambitious CO2 emissions reductions targets from purchased electricity

The Science-Based Targets initiative (SBTi) has validated LafargeHolcim’s targets to reduce its global carbon emissions. According to SBTi, LafargeHolcim’s targets are adequate and consistent with the global effort to keep temperatures below the ‘2°C’ threshold as agreed at the COP21 world climate conference in Paris.

“Our ambition to lead the industry in reducing carbon emissions is a key element of our Strategy 2022 – Building for Growth. The independent certification of our ambitious targets by the Science Based Targets initiative is a huge motivation for us to lead our industry towards low-carbon construction. Through continuous innovation in our production facilities and our product portfolio we will reduce carbon emissions even further,” said Magali Anderson, Chief Sustainability Officer.

The SBTi has approved LafargeHolcim’s commitment to reduce scope 1 GHG emissions by 10% per ton of cementitious materials by 2030 from a 2018 base year. LafargeHolcim also commits to reduce scope 2 GHG emissions from purchased electricity by 65% within the same timeframe.

LafargeHolcim’s targets, expressed in CO2 emissions per ton of cementitious materials, equate to a reduction from 576 kg in 2018 to 520 kg by 2030. With these targets LafargeHolcim is an industry leader in reducing CO2. By 2018 LafargeHolcim had already reduced its net carbon scope 1 emissions per ton of cementitious material by 25% compared to 1990.

The SBTi is a global collaboration between the Carbon Disclosure Project (CDP), the United Nations Global Compact (UNGC), the World Resources Institute (WRI) and the World Wildlife Fund for Nature (WWF).

About LafargeHolcim

LafargeHolcim is the global leader in building materials and solutions. We are active in four business segments: Cement, Aggregates, Ready-Mix Concrete and Solutions & Products. With leading positions in all regions of the world and a balanced portfolio between developing and mature markets, LafargeHolcim offers a broad range of high-quality building materials and solutions. LafargeHolcim experts solve the challenges that customers face around the world, whether they are building individual homes or major infrastructure projects. Demand for LafargeHolcim materials and solutions is driven by global population growth, urbanization, improved living standards and sustainable construction. Around 75,000 people work for the company in around 80 countries.